DBA Data[Home] [Help]

APPS.PJM_TRANSFER_CHARGES_PKG dependencies on BOM_DEPARTMENTS

Line 795: bom_departments BD

791: SELECT BD.pa_expenditure_org_id
792: INTO l_exp_org_id
793: FROM PO_DISTRIBUTIONS_ALL POD,
794: wip_operations WO ,
795: bom_departments BD
796: WHERE POD.wip_entity_id = WO.wip_entity_id
797: AND NVL(wo.repetitive_schedule_id, -99999) = NVL(POD.wip_repetitive_schedule_id, -99999)
798: AND POD.wip_operation_seq_num = WO.OPERATION_SEQ_NUM
799: AND BD.department_id = WO.department_id

Line 1226: bom_departments BD

1222: SELECT BD.pa_expenditure_org_id
1223: INTO l_exp_org_id
1224: FROM PO_DISTRIBUTIONS_ALL POD,
1225: wip_operations WO ,
1226: bom_departments BD
1227: WHERE POD.wip_entity_id = WO.wip_entity_id
1228: AND NVL(wo.repetitive_schedule_id, -99999) = NVL(POD.wip_repetitive_schedule_id, -99999)
1229: AND POD.wip_operation_seq_num = WO.OPERATION_SEQ_NUM
1230: AND BD.department_id = WO.department_id

Line 1666: bom_departments BD

1662: SELECT BD.pa_expenditure_org_id
1663: INTO l_exp_org_id
1664: FROM PO_DISTRIBUTIONS_ALL POD,
1665: wip_operations WO ,
1666: bom_departments BD
1667: WHERE POD.wip_entity_id = WO.wip_entity_id
1668: AND NVL(wo.repetitive_schedule_id, -99999) = NVL(POD.wip_repetitive_schedule_id, -99999)
1669: AND POD.wip_operation_seq_num = WO.OPERATION_SEQ_NUM
1670: AND BD.department_id = WO.department_id

Line 2094: bom_departments BD

2090: SELECT BD.pa_expenditure_org_id
2091: INTO l_exp_org_id
2092: FROM PO_DISTRIBUTIONS_ALL POD,
2093: wip_operations WO ,
2094: bom_departments BD
2095: WHERE POD.wip_entity_id = WO.wip_entity_id
2096: AND NVL(wo.repetitive_schedule_id, -99999) = NVL(POD.wip_repetitive_schedule_id, -99999)
2097: AND POD.wip_operation_seq_num = WO.OPERATION_SEQ_NUM
2098: AND BD.department_id = WO.department_id