DBA Data[Home] [Help]

APPS.RCV_OPSM_DLV_BE_PKG dependencies on MTL_PARAMETERS

Line 98: MTL_PARAMETERS MP

94: ROLV.BILLEDBYCONTACTID,
95: ROLV.GROUP_ID
96: FROM RCV_OPSM_LINE_V ROLV,
97: MTL_CROSS_REFERENCES_VL MCRV,
98: MTL_PARAMETERS MP
99: WHERE ROLV.SHIPMENT_HEADER_ID =p_shipmentheaderid
100: AND ROLV.GROUP_ID =p_groupid
101: AND ROLV.SOURCE_DOCUMENT_CODE ='RMA RECEIPT'
102: AND ROLV.LOT_CONTROL_CODE = 2

Line 210: MTL_PARAMETERS MP

206: ROMAV.SOLDTOCONTACTEMAIL
207: FROM RCV_OPSM_LINE_V ROLV,
208: RCV_OPSM_MANUFACT_ADDRESS_V ROMAV,
209: RCV_OPSM_CUSTOMERADDRESS_V ROCAV,
210: MTL_PARAMETERS MP
211: WHERE ROLV.SHIPMENT_HEADER_ID=p_shipmentheaderid
212: AND ROLV.GROUP_ID=p_groupid
213: AND ROLV.SHIPMENT_HEADER_ID=ROMAV.SHIPMENT_HEADER_ID
214: AND ROLV.SHIPMENT_LINE_ID=ROMAV.SHIPMENT_LINE_ID

Line 611: FROM MTL_PARAMETERS MP,

607: --To check whether Item is OPSM Integrated or not
608: BEGIN
609: SELECT 1
610: INTO l_count
611: FROM MTL_PARAMETERS MP,
612: MTL_CROSS_REFERENCES_VL MCRV,
613: MTL_SYSTEM_ITEMS_B MSIB
614: WHERE MSIB.ORGANIZATION_ID = v_opsm_items.ORGANIZATION_ID
615: AND MSIB.INVENTORY_ITEM_ID = v_opsm_items.ITEM_ID