DBA Data[Home] [Help]

APPS.GML_OPM_ROI_GRP dependencies on PO_VEND_MST

Line 996: From po_Vend_mst pvm,ic_whse_mst iwm,sy_orgn_mst som

992: IF p_vendor_id IS NOT NULL and p_vendor_site_id IS NOT NULL THEN
993:
994: BEGIN
995: Select pvm.vendor_no INTO l_new_lot_rec.shipvendor_no
996: From po_Vend_mst pvm,ic_whse_mst iwm,sy_orgn_mst som
997: Where pvm.OF_VENDOR_ID = p_vendor_id
998: and pvm.OF_VENDOR_SITE_ID = p_vendor_site_id
999: and iwm.mtl_organization_id = p_organization_id
1000: and iwm.orgn_code = som.orgn_code