Thursday, July 15, 2021

Group Wise Unit

 select * from hr_operating_units hou    where  hou.ORGANIZATION_ID  in (

84,

86,

89,

91,

96,

102

)


Noman: 

org_id in (83

90,

99,

1696,

2265,

2405

)


select * from hr_operating_units hou    where  hou.ORGANIZATION_ID  in (83,90,99,1696,2265,2405)



Talha:

org_id in (

94,

103,

106,

107,

108,

109,

110,

111,

2485

)


select * from hr_operating_units hou    where  hou.ORGANIZATION_ID  in (94,103,106,107,108,109,110,111,2485)



Zaber:

org_id in (

85,

87,

92,

95,

100,

101,

105,

1994

)


select * from hr_operating_units hou    where  hou.ORGANIZATION_ID  in (85,87,92,95,100,101,105,1994)



Zubair:

org_id in (

84,

86,

89,

91,

96,

102

)


select * from hr_operating_units hou    where  hou.organization_id  in (84,86,89,91,96,102)


select * from ap_invoices_all aia where aia.org_id






No comments:

Post a Comment