DBA Data[Home] [Help]

APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on MTL_INTERORG_PARAMETERS

Line 324: , mtl_interorg_parameters mip

320: , p_vendor_id vendor_id
321: , p_vendor_site_id vendor_site_id
322: , 'Y' status
323: FROM HR_ORGANIZATION_INFORMATION hoi
324: , mtl_interorg_parameters mip
325: , mtl_parameters mp
326: WHERE mip.to_organization_id = mp.organization_id
327: AND mp.organization_id = hoi.organization_id
328: AND mp.trading_partner_org_flag = 'Y'

Line 1639: mtl_interorg_parameters mip,

1635: FROM hr_organization_information hoi,
1636: po_line_locations_all plla,
1637: po_lines_all pla,
1638: po_headers_all pha,
1639: mtl_interorg_parameters mip,
1640: mtl_system_items_b msib
1641: WHERE hoi.org_information_context = 'Customer/Supplier Association'
1642: AND TO_NUMBER(hoi.org_information3) = pha.vendor_id
1643: AND TO_NUMBER(hoi.org_information4) = pha.vendor_site_id