DBA Data[Home] [Help]

APPS.PO_TAX_INTERFACE_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 3295: po_vendor_sites_all pvs, mtl_system_items_b msib

3291: AND pll.tax_name IS NOT NULL)
3292: ,pll.ship_to_organization_id --Bug#6902111
3293: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,
3294: zx_lines_det_factors zxldet, po_vendors pv,
3295: po_vendor_sites_all pvs, mtl_system_items_b msib
3296: WHERE ph.po_header_id = pll.po_header_id
3297: AND pl.po_line_id = pll.po_line_id
3298: ---Bug# 13091627 : Condition added to exclude the Release shipments for BLANKET/PLANNED PO
3299: AND pll.po_release_id IS NULL

Line 3608: LEFT OUTER JOIN mtl_system_items_b msib

3604: LEFT OUTER JOIN po_vendor_sites_all pvs
3605: ON (ph.vendor_site_id = pvs.vendor_site_id)
3606: ,po_lines_all pl--Blanket/Scheduled header and line
3607: -- Join with items table for item information
3608: LEFT OUTER JOIN mtl_system_items_b msib
3609: ON (pl.item_id = msib.inventory_item_id
3610: AND pl.org_id = msib.organization_id)
3611: ,po_line_locations_all pll
3612: -- Conditions for getting Additional Tax Attributes

Line 3955: po_vendor_sites_all pvs, mtl_system_items_b msib

3951: AND pll.tax_name IS NOT NULL)
3952: ,pll.ship_to_organization_id --Bug#6902111
3953: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,
3954: zx_lines_det_factors zxldet, po_vendors pv,
3955: po_vendor_sites_all pvs, mtl_system_items_b msib
3956: WHERE ph.po_header_id = pll.po_header_id
3957: AND pl.po_line_id = pll.po_line_id
3958: ---Bug# 13091627 : Condition added to exclude the Release shipments for BLANKET/PLANNED PO
3959: AND pll.po_release_id IS NULL

Line 4264: LEFT OUTER JOIN mtl_system_items_b msib

4260: LEFT OUTER JOIN po_vendor_sites_all pvs
4261: ON (ph.vendor_site_id = pvs.vendor_site_id)
4262: ,po_lines_all pl--Blanket/Scheduled header and line
4263: -- Join with items table for item information
4264: LEFT OUTER JOIN mtl_system_items_b msib
4265: ON (pl.item_id = msib.inventory_item_id
4266: AND pl.org_id = msib.organization_id)
4267: ,po_line_locations_all pll
4268: LEFT OUTER JOIN zx_lines_det_factors zxldet ON

Line 4552: mtl_system_items_b msib, fnd_currencies fc

4548: 'REQIMPORT', NVL2(PRL.TAX_NAME,'Y',NULL))
4549: ,prl.destination_organization_id --Bug#6902111
4550: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,
4551: zx_lines_det_factors zxldet, po_vendors pv, po_vendor_sites_all pvs,
4552: mtl_system_items_b msib, fnd_currencies fc
4553: WHERE prh.requisition_header_id = p_requisition_header_id
4554: AND prh.requisition_header_id = prl.requisition_header_id
4555: -- Conditions for getting Additional Tax Attributes
4556: -- Do not put a condition on zxldet.trx_id here because that would