DBA Data[Home] [Help]

APPS.GML_OPM_ROI_GRP dependencies on SY_ORGN_MST

Line 830: FROM IC_WHSE_MST W,SY_ORGN_MST S

826: IF l_inv_lot_status IS NOT NULL AND l_inv_lot_status <> l_default_lot_status
827: AND l_inv_loct_onhand = 0 THEN
828:
829: SELECT s.co_code,w.orgn_code INTO l_trans_rec.co_code,l_trans_rec.orgn_code
830: FROM IC_WHSE_MST W,SY_ORGN_MST S
831: WHERE w.whse_code = l_whse_code
832: and w.orgn_code = s.orgn_code;
833:
834: IF l_inv_debug = 1 THEN

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