DBA Data[Home] [Help]

APPS.GML_PO_INTERFACE dependencies on PO_LINES_ALL

Line 91: po_lines_all table*/

87: v_order_um1 SY_UOMS_MST.UM_CODE%TYPE;
88:
89:
90: /* Definitions for variables that are derived from columns of
91: po_lines_all table*/
92:
93: v_item_id PO_LINES_ALL.ITEM_ID%TYPE;
94: v_unit_meas_lookup_code PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;
95: v_unit_price PO_LINES_ALL.UNIT_PRICE%TYPE;

Line 93: v_item_id PO_LINES_ALL.ITEM_ID%TYPE;

89:
90: /* Definitions for variables that are derived from columns of
91: po_lines_all table*/
92:
93: v_item_id PO_LINES_ALL.ITEM_ID%TYPE;
94: v_unit_meas_lookup_code PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;
95: v_unit_price PO_LINES_ALL.UNIT_PRICE%TYPE;
96: v_qc_grade_wanted VARCHAR2(4);
97:

Line 94: v_unit_meas_lookup_code PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;

90: /* Definitions for variables that are derived from columns of
91: po_lines_all table*/
92:
93: v_item_id PO_LINES_ALL.ITEM_ID%TYPE;
94: v_unit_meas_lookup_code PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;
95: v_unit_price PO_LINES_ALL.UNIT_PRICE%TYPE;
96: v_qc_grade_wanted VARCHAR2(4);
97:
98: /* Definitions for variables that are derived from columns of

Line 95: v_unit_price PO_LINES_ALL.UNIT_PRICE%TYPE;

91: po_lines_all table*/
92:
93: v_item_id PO_LINES_ALL.ITEM_ID%TYPE;
94: v_unit_meas_lookup_code PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;
95: v_unit_price PO_LINES_ALL.UNIT_PRICE%TYPE;
96: v_qc_grade_wanted VARCHAR2(4);
97:
98: /* Definitions for variables that are derived from columns of
99: po_releases_all table*/

Line 210: /* Cursor to select values from po_lines_all table */

206: SELECT whse_code
207: FROM ic_whse_mst
208: WHERE MTL_ORGANIZATION_ID = v_ship_to_organization_id;
209:
210: /* Cursor to select values from po_lines_all table */
211:
212: CURSOR line_vars_cur
213: IS
214: SELECT item_id, unit_meas_lookup_code, unit_price, qc_grade qc_grade_wanted

Line 216: FROM po_lines_all

212: CURSOR line_vars_cur
213: IS
214: SELECT item_id, unit_meas_lookup_code, unit_price, qc_grade qc_grade_wanted
215: -- substrb(attribute11,1,4) qc_grade_wanted
216: FROM po_lines_all
217: WHERE po_header_id = p_po_header_id
218: AND po_line_id = p_po_line_id;
219:
220: /* Cursor to select values from po_line_locations_all table */