DBA Data[Home] [Help]

APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on PO_VENDOR_SITES_ALL

Line 657: , po_vendor_sites_all pvsa

653: /* Bug 11900144. Addition of po_line_id */
654: , mct.po_line_id
655: FROM
656: MTL_CONSUMPTION_TRANSACTIONS mct
657: , po_vendor_sites_all pvsa
658: WHERE mct.owning_organization_id = pvsa.vendor_site_id
659: AND pvsa.vendor_id = NVL(p_vendor_id,pvsa.vendor_id)
660: AND mct.owning_organization_id =
661: NVL(p_vendor_site_id,mct.owning_organization_id)

Line 807: , po_vendor_sites_all pvsa

803: /* Bug 11900144. Addition of po_line_id */
804: , mct.po_line_id
805: FROM
806: MTL_CONSUMPTION_TRANSACTIONS mct
807: , po_vendor_sites_all pvsa
808: WHERE mct.owning_organization_id = pvsa.vendor_site_id
809: AND pvsa.vendor_id = NVL(p_vendor_id,pvsa.vendor_id)
810: AND mct.owning_organization_id =
811: NVL(p_vendor_site_id,mct.owning_organization_id)

Line 889: , po_vendor_sites_all pvsa

885: /* Bug 11900144. Addition of po_line_id */
886: , mct.po_line_id
887: FROM
888: MTL_CONSUMPTION_TRANSACTIONS mct
889: , po_vendor_sites_all pvsa
890: WHERE mct.owning_organization_id = pvsa.vendor_site_id
891: AND pvsa.vendor_id = NVL(p_vendor_id,pvsa.vendor_id)
892: AND mct.owning_organization_id =
893: NVL(p_vendor_site_id,mct.owning_organization_id)

Line 1480: po_vendor_sites_all povs

1476: l_vendor_ship_to_location
1477: , l_vendor_bill_to_location
1478: , l_vendor_id --Bug 4723164
1479: FROM
1480: po_vendor_sites_all povs
1481: , po_vendors pov
1482: WHERE povs.vendor_id = pov.vendor_id
1483: AND povs.vendor_site_id = l_vendor_site_id;
1484:

Line 1557: po_vendor_sites_all

1553: pay_on_code
1554: INTO
1555: l_pay_on_code
1556: FROM
1557: po_vendor_sites_all
1558: WHERE vendor_site_id = l_vendor_site_id;
1559:
1560: IF NVL(l_pay_on_code,'NONE') IN ('RECEIPT_AND_USE','USE')
1561: THEN

Line 2035: po_vendor_sites_all

2031: vendor_id
2032: INTO
2033: l_vendor_id
2034: FROM
2035: po_vendor_sites_all
2036: WHERE vendor_site_id = l_owning_organization_id;
2037:
2038: IF (l_debug = 1)
2039: THEN

Line 3540: FROM po_vendor_sites_all pvsa

3536: -- Find the vendor location information
3537: -- Bug 5092489. Query modified
3538: SELECT pvsa.vendor_id
3539: INTO l_vendor_id
3540: FROM po_vendor_sites_all pvsa
3541: WHERE pvsa.vendor_site_id = l_owning_org_tab(i)
3542: AND ROWNUM = 1;
3543:
3544: IF (l_debug = 1)

Line 4574: and exists(select /*+ no_unnest */ 1 from po_vendor_sites_all pvsa

4570: AND mmt.inventory_item_id = NVL(p_inventory_item_id, mmt.inventory_item_id)
4571: AND mmt.transaction_type_id = 74
4572: AND mmt.transaction_action_id = 6
4573: AND mmt.transaction_source_type_id = 1
4574: and exists(select /*+ no_unnest */ 1 from po_vendor_sites_all pvsa
4575: where mmt.owning_organization_id = pvsa.vendor_site_id
4576: and pvsa.vendor_id = NVL(p_vendor_id, pvsa.vendor_id)))) ;
4577: exception
4578: when no_data_found then

Line 4606: FROM mtl_material_transactions mmt,po_vendor_sites_all pvsa

4602: l_batch_id, mmt.transaction_source_id,
4603: mmt.inventory_item_id, mmt.distribution_account_id,
4604: mmt.organization_id, mmt.owning_organization_id,
4605: mmt.transaction_date
4606: FROM mtl_material_transactions mmt,po_vendor_sites_all pvsa
4607: WHERE mct.transaction_id = mmt.transaction_id
4608: AND mmt.owning_organization_id = pvsa.vendor_site_id
4609: AND (p_vendor_id IS NULL OR pvsa.vendor_id = p_vendor_id)
4610: AND (p_vendor_site_id IS NULL OR pvsa.vendor_site_id =