APPS.GML_PO_GLDIST dependencies on CPG_ORAGEMS_MAPPING

Line 2009: FROM cpg_oragems_mapping

2005: x_combination_id NUMBER;
2006:
2007: CURSOR Cur_get_std_poinf IS
2008: SELECT po_header_id,po_line_id,po_line_location_id
2009: FROM cpg_oragems_mapping
2010: WHERE po_id = v_po_id AND
2011: line_id = v_line_id;
2012:
2013: CURSOR Cur_get_blk_poinf IS

Line 2015: FROM cpg_oragems_mapping

2011: line_id = v_line_id;
2012:
2013: CURSOR Cur_get_blk_poinf IS
2014: SELECT po_header_id, po_line_id, po_line_location_id, po_release_id
2015: FROM cpg_oragems_mapping
2016: WHERE po_id = v_po_id AND
2017: line_id = v_line_id;
2018:
2019: CURSOR Cur_get_pln_poinf IS

Line 2021: FROM cpg_oragems_mapping

2017: line_id = v_line_id;
2018:
2019: CURSOR Cur_get_pln_poinf IS
2020: SELECT po_header_id, po_line_id, po_line_location_id, po_release_id
2021: FROM cpg_oragems_mapping
2022: WHERE po_id = v_po_id AND line_id = v_line_id;
2023:
2024: /* B1994882 */
2025: CURSOR cur_get_ccid(v_act_ttl_typ NUMBER,v_po_id NUMBER,v_line_id NUMBER) IS

Line 2028: cpg_oragems_mapping map,

2024: /* B1994882 */
2025: CURSOR cur_get_ccid(v_act_ttl_typ NUMBER,v_po_id NUMBER,v_line_id NUMBER) IS
2026: SELECT cc.code_combination_id
2027: FROM gl_code_combinations_kfv cc,
2028: cpg_oragems_mapping map,
2029: gl_accu_mst acu,
2030: gl_acct_mst act,
2031: po_dist_dtl pdd,
2032: po_distributions_all pod,

Line 2128: from cpg_oragems_mapping for the corresponding po_id and line_id (and not bpo_id and bpo_line_id)

2124: then
2125:
2126: /* In planned purchase order -- distributions are generated on the OPM side only when we create a
2127: release against it and in that case there use po_header_id,po_line_id,po_line_location_id and po_release_id
2128: from cpg_oragems_mapping for the corresponding po_id and line_id (and not bpo_id and bpo_line_id)
2129: */
2130: OPEN Cur_get_pln_poinf;
2131: FETCH Cur_get_pln_poinf INTO v_po_header_id, v_po_line_id,
2132: v_po_line_location_id, v_po_release_id;