DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on PO_LINES_ALL

Line 3601: FROM po_lines_all poa, po_distributions_all pda

3597: /* 6118897 ---- end */
3598:
3599:
3600: SELECT sum(pda.quantity_ordered) INTO l_po_ordered_qty
3601: FROM po_lines_all poa, po_distributions_all pda
3602: WHERE poa.po_line_id = pda.po_line_id
3603: AND pda.wip_entity_id = l_eam_mat_req_rec.wip_entity_id
3604: AND pda.destination_organization_id= l_eam_mat_req_rec.organization_id
3605: AND pda.wip_operation_seq_num = l_eam_mat_req_rec.operation_seq_num