DBA Data[Home] [Help]

APPS.GMF_RCV_ACCOUNTING_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 8163: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;

8159: l_parent_trx_type rcv_transactions.transaction_type%TYPE;
8160: l_grparent_trx_id rcv_transactions.transaction_id%TYPE;
8161: l_grparent_trx_type rcv_transactions.transaction_type%TYPE;
8162: l_po_header_id po_headers_all.po_header_id%TYPE;
8163: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
8164: l_shipment_type po_line_locations_all.shipment_type%TYPE;
8165: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
8166: l_api_version NUMBER := 1.0;
8167: l_return_status VARCHAR2 (100);

Line 8164: l_shipment_type po_line_locations_all.shipment_type%TYPE;

8160: l_grparent_trx_id rcv_transactions.transaction_id%TYPE;
8161: l_grparent_trx_type rcv_transactions.transaction_type%TYPE;
8162: l_po_header_id po_headers_all.po_header_id%TYPE;
8163: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
8164: l_shipment_type po_line_locations_all.shipment_type%TYPE;
8165: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
8166: l_api_version NUMBER := 1.0;
8167: l_return_status VARCHAR2 (100);
8168: l_msg_count NUMBER (38);

Line 8586: FROM po_line_locations_all a,

8582: /* INVCONV ANTHIYAG Bug#5529309 18-Sep-2006 Start */
8583: BEGIN
8584: SELECT nvl(b.process_enabled_flag, 'N')
8585: INTO l_process_enabled_flag
8586: FROM po_line_locations_all a,
8587: mtl_parameters b
8588: WHERE a.line_location_id = p_po_line_location_id
8589: AND b.organization_id = a.ship_to_organization_id;
8590: EXCEPTION