DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on BOM_RESOURCES

Line 5812: FROM BOM_RESOURCES BOM,

5808: WOR.resource_id resource_id,
5809: BOM.resource_type,
5810: WOR.uom_code uom_code,
5811: WOR.usage_rate_or_amount usage_rate_or_amount
5812: FROM BOM_RESOURCES BOM,
5813: WIP_OPERATION_RESOURCES WOR,
5814: AHL_WORKORDER_OPERATIONS WOP,
5815: AHL_WORKORDERS CWO,
5816: WIP_SCHED_RELATIONSHIPS REL

Line 5857: FROM BOM_RESOURCES BOM,

5853: WOR.resource_id resource_id,
5854: BOM.resource_type,
5855: WOR.uom_code uom_code,
5856: WOR.usage_rate_or_amount usage_rate_or_amount
5857: FROM BOM_RESOURCES BOM,
5858: WIP_OPERATION_RESOURCES WOR,
5859: AHL_WORKORDER_OPERATIONS WOP,
5860: AHL_WORKORDERS CWO
5861: WHERE BOM.resource_type IN ( 1 , 2 )

Line 7964: FROM BOM_RESOURCES BOM,

7960: WOR.resource_id resource_id,
7961: BOM.resource_type,
7962: WOR.uom_code uom_code,
7963: WOR.usage_rate_or_amount usage_rate_or_amount
7964: FROM BOM_RESOURCES BOM,
7965: WIP_OPERATION_RESOURCES WOR,
7966: AHL_WORKORDER_OPERATIONS WOP,
7967: AHL_WORKORDERS WO
7968: WHERE BOM.resource_type IN ( 1 , 2 )

Line 9930: BOM_RESOURCES BOMR

9926: MAX(WIPT.TRANSACTION_DATE + (WIPT.TRANSACTION_QUANTITY/24))
9927: -- Using the transaction quantity above since we know the
9928: -- transaction uom is in hours
9929: FROM WIP_TRANSACTIONS WIPT,
9930: BOM_RESOURCES BOMR
9931: WHERE WIPT.RESOURCE_ID = BOMR.RESOURCE_ID
9932: AND WIPT.WIP_ENTITY_ID = x_wip_entity_id
9933: AND WIPT.OPERATION_SEQ_NUM = x_operation_seq_num
9934: AND BOMR.RESOURCE_TYPE = 2; -- Person