APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on PO_VENDOR_SITES_ALL

Line 567: , lp_supplier_site_code_from po_vendor_sites_all.vendor_site_code%TYPE

563: CURSOR l_cur_get_tp_inv_org_info
564: ( lp_oem_inv_org_id mtl_interorg_parameters.from_organization_id%TYPE
565: , lp_supplier_name_from po_vendors.vendor_name%TYPE
566: , lp_supplier_name_to po_vendors.vendor_name%TYPE
567: , lp_supplier_site_code_from po_vendor_sites_all.vendor_site_code%TYPE
568: , lp_supplier_site_code_to po_vendor_sites_all.vendor_site_code%TYPE
569: )
570: IS
571: SELECT mip.to_organization_id --tp_org_id

Line 568: , lp_supplier_site_code_to po_vendor_sites_all.vendor_site_code%TYPE

564: ( lp_oem_inv_org_id mtl_interorg_parameters.from_organization_id%TYPE
565: , lp_supplier_name_from po_vendors.vendor_name%TYPE
566: , lp_supplier_name_to po_vendors.vendor_name%TYPE
567: , lp_supplier_site_code_from po_vendor_sites_all.vendor_site_code%TYPE
568: , lp_supplier_site_code_to po_vendor_sites_all.vendor_site_code%TYPE
569: )
570: IS
571: SELECT mip.to_organization_id --tp_org_id
572: ,mp.organization_code --tp_org_code

Line 577: ,po_vendor_sites_all pvs

573: ,pv.vendor_id --supplier_id
574: ,pvs.vendor_site_id --supplier_site_id
575: FROM mtl_interorg_parameters mip
576: ,po_vendors pv
577: ,po_vendor_sites_all pvs
578: ,hr_organization_information hoi
579: ,mtl_parameters mp
580: WHERE mip.from_organization_id = lp_oem_inv_org_id
581: --AND mip.shikyu_enabled_flag = 'Y'

Line 605: l_supplier_site_id po_vendor_sites_all.vendor_site_id%TYPE;

601:
602: l_tp_inv_org_id mtl_parameters.organization_id%TYPE;
603: l_tp_inv_org_code mtl_parameters.organization_code%TYPE;
604: l_supplier_id po_vendors.vendor_id%TYPE;
605: l_supplier_site_id po_vendor_sites_all.vendor_site_id%TYPE;
606:
607: l_api_name CONSTANT VARCHAR2(30) := 'get_onhand_components';
608:
609: BEGIN

Line 3287: ,po_vendor_sites_all pvs

3283: ,rcv_transactions rcv
3284: ,mtl_parameters mp_oem
3285: ,mtl_parameters mp_tp
3286: ,po_vendors pv
3287: ,po_vendor_sites_all pvs
3288: ,po_headers_all ph
3289: ,po_vendor_contacts pvc
3290: ,mtl_system_items_vl item_v
3291: ,po_lines_all pl

Line 3930: ,po_vendor_sites_all pvs

3926: -- Amy added to fix bug 5583680 start
3927: ,hr_all_organization_units_tl oem_haoutl
3928: ,hr_organization_information tp_hoi
3929: ,po_vendors pv
3930: ,po_vendor_sites_all pvs
3931: -- Amy added to fix bug 5583680 end
3932: WHERE oola.header_id = ooha.header_id
3933: AND plla.po_line_id = pla.po_line_id
3934: AND plla.po_header_id = pha.po_header_id