APPS.RCV_WSH_INTERFACE_PKG dependencies on MTL_PARAMETERS

Line 1603: mtl_parameters mp

1599: SELECT rt.subinventory, rt.locator_id, rt.organization_id, rti.rma_reference, mp.WMS_ENABLED_FLAG -- Bug 12974284
1600: INTO l_deliver_subinv, l_deliver_locator, l_receipt_org, l_txn_reference, l_wms_rec_org -- Bug 12974284
1601: FROM rcv_transactions rt,
1602: rcv_transactions_interface rti,
1603: mtl_parameters mp
1604: WHERE rt.transaction_id = rti.parent_transaction_id
1605: AND rti.interface_transaction_id = p_wdd_rec.source_line_id
1606: AND rt.transaction_type = 'DELIVER'
1607: AND mp.organization_id = rt.organization_id;

Line 1628: FROM mtl_parameters

1624: l_transfer_lpn_id := null; --RTV2 rtv project phase 2
1625:
1626: SELECT ap_accrual_account
1627: INTO l_account_id
1628: FROM mtl_parameters
1629: WHERE organization_id = p_wdd_rec.organization_id;
1630:
1631: IF (g_asn_debug = 'Y') THEN
1632: asn_debug.put_line('l_account_id : ' || l_account_id);

Line 1866: FROM mtl_parameters

1862: IF (rti_rec.transfer_lpn_id IS NOT NULL) THEN
1863: IF (rti_rec.to_organization_id <> p_wdd_rec.organization_id) THEN
1864: SELECT WMS_ENABLED_FLAG
1865: INTO l_rec_wms_org
1866: FROM mtl_parameters
1867: WHERE organization_id = rti_rec.to_organization_id;
1868:
1869: IF (NVL(l_rec_wms_org, 'N') = 'N') THEN
1870: rti_rec.transfer_lpn_id := NULL;