APPS.GMF_RCV_ACCOUNTING_PKG dependencies on MTL_PARAMETERS

Line 2300: FROM mtl_parameters mp

2296: l_stmt_num := 60;
2297:
2298: SELECT cost_of_sales_account
2299: INTO l_ic_coss_acct_id
2300: FROM mtl_parameters mp
2301: WHERE mp.organization_id = p_rcv_accttxn.organization_id;
2302:
2303: l_stmt_num := 70;
2304: get_hookaccount

Line 2401: FROM mtl_parameters mp

2397: l_stmt_num := 90;
2398:
2399: SELECT cost_of_sales_account
2400: INTO l_ic_coss_acct_id
2401: FROM mtl_parameters mp
2402: WHERE mp.organization_id = p_rcv_accttxn.organization_id;
2403:
2404: l_stmt_num := 100;
2405: get_hookaccount

Line 8537: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE; /* INVCONV ANTHIYAG Bug#5529309 18-Sep-2006 */

8533: l_trx_flow_header_id NUMBER := NULL;
8534: l_drop_ship_flag NUMBER := NULL;
8535: l_opm_flag NUMBER;
8536: l_cr_flag BOOLEAN;
8537: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE; /* INVCONV ANTHIYAG Bug#5529309 18-Sep-2006 */
8538:
8539: -- Cursor to get all parent receive transactions
8540: -- for a given po_header or po_release
8541: CURSOR c_parent_receive_txns_csr

Line 8544: FROM rcv_transactions a, mtl_parameters b

8540: -- for a given po_header or po_release
8541: CURSOR c_parent_receive_txns_csr
8542: IS
8543: SELECT a.transaction_id, a.organization_id
8544: FROM rcv_transactions a, mtl_parameters b
8545: WHERE (
8546: (a.transaction_type = 'RECEIVE' AND a.parent_transaction_id = -1)
8547: OR
8548: a.transaction_type = 'MATCH'

Line 8562: FROM rcv_transactions a, mtl_parameters b

8558: -- a parent receive transaction.
8559: CURSOR c_deliver_txns_csr (l_par_txn IN NUMBER)
8560: IS
8561: SELECT a.transaction_id, a.po_distribution_id
8562: FROM rcv_transactions a, mtl_parameters b
8563: WHERE a.transaction_type = 'DELIVER'
8564: AND a.organization_id = b.organization_id
8565: AND NVL(b.process_enabled_flag, 'N') = 'Y'
8566: AND a.parent_transaction_id = l_par_txn;

Line 8587: mtl_parameters b

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
8591: WHEN OTHERS THEN