DBA Data[Home] [Help]

APPS.GMF_RCV_ACCOUNTING_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 8108: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;

8104: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
8105: l_grparent_trx_id rcv_transactions.transaction_id%TYPE;
8106: l_grparent_trx_type rcv_transactions.transaction_type%TYPE;
8107: l_po_header_id po_headers_all.po_header_id%TYPE;
8108: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
8109: l_shipment_type po_line_locations_all.shipment_type%TYPE;
8110: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
8111: l_api_version NUMBER := 1.0;
8112: l_return_status VARCHAR2 (100);

Line 8109: l_shipment_type po_line_locations_all.shipment_type%TYPE;

8105: l_grparent_trx_id rcv_transactions.transaction_id%TYPE;
8106: l_grparent_trx_type rcv_transactions.transaction_type%TYPE;
8107: l_po_header_id po_headers_all.po_header_id%TYPE;
8108: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
8109: l_shipment_type po_line_locations_all.shipment_type%TYPE;
8110: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
8111: l_api_version NUMBER := 1.0;
8112: l_return_status VARCHAR2 (100);
8113: l_msg_count NUMBER (38);

Line 8528: FROM po_line_locations_all a,

8524: /* INVCONV ANTHIYAG Bug#5529309 18-Sep-2006 Start */
8525: BEGIN
8526: SELECT nvl(b.process_enabled_flag, 'N')
8527: INTO l_process_enabled_flag
8528: FROM po_line_locations_all a,
8529: mtl_parameters b
8530: WHERE a.line_location_id = p_po_line_location_id
8531: AND b.organization_id = a.ship_to_organization_id;
8532: EXCEPTION