APPS.GML_PO_INTERFACE dependencies on PO_RELEASES_ALL

Line 99: po_releases_all table*/

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*/
100:
101: v_release_num PO_RELEASES_ALL.RELEASE_NUM%TYPE;
102:
103: /* Definitions for variables that are derived from columns of

Line 101: v_release_num PO_RELEASES_ALL.RELEASE_NUM%TYPE;

97:
98: /* Definitions for variables that are derived from columns of
99: po_releases_all table*/
100:
101: v_release_num PO_RELEASES_ALL.RELEASE_NUM%TYPE;
102:
103: /* Definitions for variables that are derived from columns of
104: po_line_locations_all table*/
105:

Line 236: /* Cursor to select release_num from po_releases_all table */

232: WHERE po_header_id = p_po_header_id
233: AND po_line_id = p_po_line_id
234: AND line_location_id = p_po_line_location_id;
235:
236: /* Cursor to select release_num from po_releases_all table */
237:
238: CURSOR rel_num_cur
239: IS
240: SELECT release_num

Line 241: FROM po_releases_all

237:
238: CURSOR rel_num_cur
239: IS
240: SELECT release_num
241: FROM po_releases_all
242: WHERE po_release_id = v_po_release_id;
243:
244: /* Cursor to select values from mtl_system_items table */
245:

Line 288: FROM po_releases_all

284: /* Uday Phadtare B1410454 Select the orgn code for the release */
285: CURSOR opm_rel_orgn_cur
286: IS
287: SELECT substr(attribute15,1,4) opm_rel_orgn_code
288: FROM po_releases_all
289: WHERE po_header_id = p_po_header_id
290: AND po_release_id = v_po_release_id;
291:
292: /* BEGIN - Bug 1427876 */

Line 417: /* Select the OPM orgn Code from the PO_RELEASES_ALL table, if it is

413: v_db_promised_date := v_need_by_date;
414: END IF;
415:
416: -- Begin B1410454
417: /* Select the OPM orgn Code from the PO_RELEASES_ALL table, if it is
418: release, else the v_gemms_orgn_code will be from the PO_HEADERS_ALL
419: table for all other purposes. If the v_opm_rel_orgn_code is NOT NULL
420: then it will be used , else the v_gemms_orgn_code from the PO_HEAD
421: ERS_ALL will be used */