APPS.EAM_AUTOMATICEST dependencies on WIP_CONSTANTS

Line 127: IN ( WIP_CONSTANTS.UNRELEASED , WIP_CONSTANTS.RELEASED ,

123: INTO l_wip_entity_tbl
124: FROM WIP_REQUIREMENT_OPERATIONS wro , WIP_DISCRETE_JOBS wdj
125: WHERE wdj.wip_entity_id = wro.wip_entity_id
126: AND wdj.status_type
127: IN ( WIP_CONSTANTS.UNRELEASED , WIP_CONSTANTS.RELEASED ,
128: WIP_CONSTANTS.COMP_CHRG , WIP_CONSTANTS.HOLD ,
129: WIP_CONSTANTS.DRAFT )
130: AND wro.inventory_item_id = p_inv_item_id
131: AND wro.organization_id = p_org_id;

Line 128: WIP_CONSTANTS.COMP_CHRG , WIP_CONSTANTS.HOLD ,

124: FROM WIP_REQUIREMENT_OPERATIONS wro , WIP_DISCRETE_JOBS wdj
125: WHERE wdj.wip_entity_id = wro.wip_entity_id
126: AND wdj.status_type
127: IN ( WIP_CONSTANTS.UNRELEASED , WIP_CONSTANTS.RELEASED ,
128: WIP_CONSTANTS.COMP_CHRG , WIP_CONSTANTS.HOLD ,
129: WIP_CONSTANTS.DRAFT )
130: AND wro.inventory_item_id = p_inv_item_id
131: AND wro.organization_id = p_org_id;
132:

Line 129: WIP_CONSTANTS.DRAFT )

125: WHERE wdj.wip_entity_id = wro.wip_entity_id
126: AND wdj.status_type
127: IN ( WIP_CONSTANTS.UNRELEASED , WIP_CONSTANTS.RELEASED ,
128: WIP_CONSTANTS.COMP_CHRG , WIP_CONSTANTS.HOLD ,
129: WIP_CONSTANTS.DRAFT )
130: AND wro.inventory_item_id = p_inv_item_id
131: AND wro.organization_id = p_org_id;
132:
133: l_stmt_num := 20;

Line 194: IN ( WIP_CONSTANTS.UNRELEASED , WIP_CONSTANTS.RELEASED ,

190: INTO l_wip_entity_tbl
191: FROM WIP_OPERATION_RESOURCES wor , WIP_DISCRETE_JOBS wdj
192: WHERE wdj.wip_entity_id = wor.wip_entity_id
193: AND wdj.status_type
194: IN ( WIP_CONSTANTS.UNRELEASED , WIP_CONSTANTS.RELEASED ,
195: WIP_CONSTANTS.COMP_CHRG , WIP_CONSTANTS.HOLD ,
196: WIP_CONSTANTS.DRAFT )
197: AND wor.resource_id = p_resource_id
198: AND wor.organization_id = p_org_id;

Line 195: WIP_CONSTANTS.COMP_CHRG , WIP_CONSTANTS.HOLD ,

191: FROM WIP_OPERATION_RESOURCES wor , WIP_DISCRETE_JOBS wdj
192: WHERE wdj.wip_entity_id = wor.wip_entity_id
193: AND wdj.status_type
194: IN ( WIP_CONSTANTS.UNRELEASED , WIP_CONSTANTS.RELEASED ,
195: WIP_CONSTANTS.COMP_CHRG , WIP_CONSTANTS.HOLD ,
196: WIP_CONSTANTS.DRAFT )
197: AND wor.resource_id = p_resource_id
198: AND wor.organization_id = p_org_id;
199:

Line 196: WIP_CONSTANTS.DRAFT )

192: WHERE wdj.wip_entity_id = wor.wip_entity_id
193: AND wdj.status_type
194: IN ( WIP_CONSTANTS.UNRELEASED , WIP_CONSTANTS.RELEASED ,
195: WIP_CONSTANTS.COMP_CHRG , WIP_CONSTANTS.HOLD ,
196: WIP_CONSTANTS.DRAFT )
197: AND wor.resource_id = p_resource_id
198: AND wor.organization_id = p_org_id;
199:
200: l_stmt_num := 20;