DBA Data[Home] [Help]

APPS.GML_PO_SYNCH dependencies on CPG_COST_DTL

Line 1042: FROM cpg_cost_dtl

1038: CURSOR aqcst_cur IS
1039: SELECT aqui_cost_id, cost_amount, incl_ind,
1040: last_update_date, created_by, creation_date, last_updated_by,
1041: last_update_login
1042: FROM cpg_cost_dtl
1043: WHERE po_header_id = v_po_header_id
1044: AND po_line_id = v_po_line_id
1045: AND line_location_id = v_line_location_id;
1046:

Line 1053: FROM cpg_cost_dtl b

1049: FROM po_cost_dtl a
1050: WHERE pos_id = v_po_id
1051: AND line_id = v_line_id
1052: AND NOT EXISTS (SELECT 'Y'
1053: FROM cpg_cost_dtl b
1054: WHERE b.po_header_id = v_po_header_id
1055: AND b.po_line_id = v_po_line_id
1056: AND b.line_location_id = v_line_location_id
1057: AND b.aqui_cost_id = a.aqui_cost_id