DBA Data[Home] [Help]

APPS.OKE_FLOWDOWN_UTILS dependencies on PO_LINES_ALL

Line 36: FROM po_distributions_all D , po_lines_all L

32: AND wip_entity_id = C_Job_ID;
33:
34: CURSOR C_PO_Line ( C_Line_ID NUMBER ) IS
35: SELECT distinct L.oke_contract_header_id , D.oke_contract_line_id
36: FROM po_distributions_all D , po_lines_all L
37: WHERE D.po_line_id = C_Line_ID
38: AND L.po_line_id = D.po_line_id;
39:
40: CURSOR C_PO_Dist ( C_Dist_ID NUMBER ) IS

Line 42: FROM po_distributions_all D , po_lines_all L

38: AND L.po_line_id = D.po_line_id;
39:
40: CURSOR C_PO_Dist ( C_Dist_ID NUMBER ) IS
41: SELECT L.oke_contract_header_id , D.oke_contract_line_id , D.project_id , D.task_id
42: FROM po_distributions_all D , po_lines_all L
43: WHERE D.po_distribution_id = C_Dist_ID
44: AND L.po_line_id = D.po_line_id;
45:
46: CURSOR C_Req_Line ( C_Line_ID NUMBER ) IS