eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on PO_VENDOR_SITES_ALL

Line 690: , po_vendor_sites_all pvsa

686: , mct.global_agreement_flag
687: , SUM(mct.net_qty)
688: FROM
689: MTL_CONSUMPTION_TRANSACTIONS mct
690: , po_vendor_sites_all pvsa
691: WHERE mct.owning_organization_id = pvsa.vendor_site_id
692: AND pvsa.vendor_id = NVL(p_vendor_id,pvsa.vendor_id)
693: AND mct.owning_organization_id =
694: NVL(p_vendor_site_id,mct.owning_organization_id)

Line 745: , po_vendor_sites_all pvsa

741: , mct.global_agreement_flag
742: FROM
743: MTL_CONSUMPTION_TRANSACTIONS mct
744: , MTL_MATERIAL_TRANSACTIONS mmt
745: , po_vendor_sites_all pvsa
746: WHERE mct.transaction_id = mmt.transaction_id
747: AND mmt.owning_organization_id = pvsa.vendor_site_id
748: AND pvsa.vendor_id = NVL(p_vendor_id,pvsa.vendor_id)
749: AND mmt.owning_organization_id =

Line 871: , po_vendor_sites_all pvsa

867: , mct.global_agreement_flag
868: , SUM(mct.net_qty)
869: FROM
870: MTL_CONSUMPTION_TRANSACTIONS mct
871: , po_vendor_sites_all pvsa
872: WHERE mct.owning_organization_id = pvsa.vendor_site_id
873: AND pvsa.vendor_id = NVL(p_vendor_id,pvsa.vendor_id)
874: AND mct.owning_organization_id =
875: NVL(p_vendor_site_id,mct.owning_organization_id)

Line 955: , po_vendor_sites_all pvsa

951: , mct.global_agreement_flag
952: FROM
953: MTL_CONSUMPTION_TRANSACTIONS mct
954: , MTL_MATERIAL_TRANSACTIONS mmt
955: , po_vendor_sites_all pvsa
956: WHERE mct.transaction_id = mmt.transaction_id
957: AND mmt.owning_organization_id = pvsa.vendor_site_id
958: AND pvsa.vendor_id = NVL(p_vendor_id,pvsa.vendor_id)
959: AND mmt.owning_organization_id =

Line 1018: , po_vendor_sites_all pvsa

1014: , mct.global_agreement_flag
1015: FROM
1016: MTL_CONSUMPTION_TRANSACTIONS mct
1017: , MTL_MATERIAL_TRANSACTIONS mmt
1018: , po_vendor_sites_all pvsa
1019: WHERE mct.transaction_id = mmt.transaction_id
1020: AND mmt.owning_organization_id = pvsa.vendor_site_id
1021: AND pvsa.vendor_id = NVL(p_vendor_id,pvsa.vendor_id)
1022: AND mmt.owning_organization_id =

Line 1073: , po_vendor_sites_all pvsa

1069: , mct.global_agreement_flag
1070: , SUM(mct.net_qty)
1071: FROM
1072: MTL_CONSUMPTION_TRANSACTIONS mct
1073: , po_vendor_sites_all pvsa
1074: WHERE mct.owning_organization_id = pvsa.vendor_site_id
1075: AND pvsa.vendor_id = NVL(p_vendor_id,pvsa.vendor_id)
1076: AND mct.owning_organization_id =
1077: NVL(p_vendor_site_id,mct.owning_organization_id)

Line 1685: po_vendor_sites_all povs

1681: l_vendor_ship_to_location
1682: , l_vendor_bill_to_location
1683: , l_vendor_id --Bug 4723164
1684: FROM
1685: po_vendor_sites_all povs
1686: , po_vendors pov
1687: WHERE povs.vendor_id = pov.vendor_id
1688: AND povs.vendor_site_id = l_vendor_site_id;
1689:

Line 1762: po_vendor_sites_all

1758: pay_on_code
1759: INTO
1760: l_pay_on_code
1761: FROM
1762: po_vendor_sites_all
1763: WHERE vendor_site_id = l_vendor_site_id;
1764:
1765: IF NVL(l_pay_on_code,'NONE') IN ('RECEIPT_AND_USE','USE')
1766: THEN

Line 2322: po_vendor_sites_all

2318: vendor_id
2319: INTO
2320: l_vendor_id
2321: FROM
2322: po_vendor_sites_all
2323: WHERE vendor_site_id = l_owning_organization_id;
2324:
2325: IF (l_debug = 1)
2326: THEN

Line 3682: FROM po_vendor_sites_all pvsa

3678: -- Find the vendor location information
3679: -- Bug 5092489. Query modified
3680: SELECT pvsa.vendor_id
3681: INTO l_vendor_id
3682: FROM po_vendor_sites_all pvsa
3683: WHERE pvsa.vendor_site_id = l_owning_org_tab(i)
3684: AND ROWNUM = 1;
3685:
3686: IF (l_debug = 1)

Line 4804: , po_vendor_sites_all pvsa

4800: l_count
4801: FROM
4802: MTL_CONSUMPTION_TRANSACTIONS mct
4803: , MTL_MATERIAL_TRANSACTIONS mmt
4804: , po_vendor_sites_all pvsa
4805: WHERE mct.transaction_id = mmt.transaction_id
4806: AND mmt.owning_organization_id = pvsa.vendor_site_id
4807: AND pvsa.vendor_id = NVL(p_vendor_id, pvsa.vendor_id)
4808: AND ( mct.batch_id = l_batch_id OR mct.batch_id IS NULL)

Line 4843: FROM mtl_material_transactions mmt,po_vendor_sites_all pvsa

4839: l_batch_id, mmt.transaction_source_id,
4840: mmt.inventory_item_id, mmt.distribution_account_id,
4841: mmt.organization_id, mmt.owning_organization_id,
4842: mmt.transaction_date
4843: FROM mtl_material_transactions mmt,po_vendor_sites_all pvsa
4844: WHERE mct.transaction_id = mmt.transaction_id
4845: AND mmt.owning_organization_id = pvsa.vendor_site_id
4846: AND (p_vendor_id IS NULL OR pvsa.vendor_id = p_vendor_id)
4847: AND (p_vendor_site_id IS NULL OR pvsa.vendor_site_id =

Line 4880: , po_vendor_sites_all pvsa

4876: mmt.transaction_source_id
4877: FROM
4878: mtl_consumption_transactions mct
4879: , mtl_material_transactions mmt
4880: , po_vendor_sites_all pvsa
4881: WHERE mct.transaction_id = mmt.transaction_id
4882: AND mmt.owning_organization_id = pvsa.vendor_site_id
4883: --AND mct.consumption_processed_flag <>''Y''
4884: --Bug 5113064

Line 4901: , po_vendor_sites_all pvsa

4897: mmt.transaction_source_id
4898: FROM
4899: mtl_consumption_transactions mct
4900: , mtl_material_transactions mmt
4901: , po_vendor_sites_all pvsa
4902: WHERE mct.transaction_id = mmt.transaction_id
4903: AND mmt.owning_organization_id = pvsa.vendor_site_id
4904: --AND mct.consumption_processed_flag <> ''Y''
4905: --Bug 5113064

Line 4921: , po_vendor_sites_all pvsa

4917: mmt.transaction_source_id
4918: FROM
4919: mtl_consumption_transactions mct
4920: , mtl_material_transactions mmt
4921: , po_vendor_sites_all pvsa
4922: WHERE mct.transaction_id = mmt.transaction_id
4923: AND mmt.owning_organization_id = pvsa.vendor_site_id
4924: --AND mct.consumption_processed_flag <> ''Y''
4925: --Bug 5113064

Line 4941: , po_vendor_sites_all pvsa

4937: mmt.transaction_source_id
4938: FROM
4939: mtl_consumption_transactions mct
4940: , mtl_material_transactions mmt
4941: , po_vendor_sites_all pvsa
4942: WHERE mct.transaction_id = mmt.transaction_id
4943: AND mmt.owning_organization_id = pvsa.vendor_site_id
4944: --AND mct.consumption_processed_flag <> ''Y''
4945: --Bug 5113064

Line 4960: , po_vendor_sites_all pvsa

4956: mmt.transaction_source_id
4957: FROM
4958: mtl_consumption_transactions mct
4959: , mtl_material_transactions mmt
4960: , po_vendor_sites_all pvsa
4961: WHERE mct.transaction_id = mmt.transaction_id
4962: AND mmt.owning_organization_id = pvsa.vendor_site_id
4963: --AND mct.consumption_processed_flag <> ''Y''
4964: --Bug 5113064

Line 4980: , po_vendor_sites_all pvsa

4976: mmt.transaction_source_id
4977: FROM
4978: mtl_consumption_transactions mct
4979: , mtl_material_transactions mmt
4980: , po_vendor_sites_all pvsa
4981: WHERE mct.transaction_id = mmt.transaction_id
4982: AND mmt.owning_organization_id = pvsa.vendor_site_id
4983: --AND mct.consumption_processed_flag <> ''Y''
4984: --Bug 5113064

Line 4999: , po_vendor_sites_all pvsa

4995: mmt.transaction_source_id
4996: FROM
4997: mtl_consumption_transactions mct
4998: , mtl_material_transactions mmt
4999: , po_vendor_sites_all pvsa
5000: WHERE mct.transaction_id = mmt.transaction_id
5001: AND mmt.owning_organization_id = pvsa.vendor_site_id
5002: --AND mct.consumption_processed_flag <> ''Y''
5003: --Bug 5113064

Line 5018: , po_vendor_sites_all pvsa

5014: mmt.transaction_source_id
5015: FROM
5016: mtl_consumption_transactions mct
5017: , mtl_material_transactions mmt
5018: , po_vendor_sites_all pvsa
5019: WHERE mct.transaction_id = mmt.transaction_id
5020: AND mmt.owning_organization_id = pvsa.vendor_site_id
5021: --AND mct.consumption_processed_flag <> ''Y''
5022: --Bug 5113064

Line 5036: , po_vendor_sites_all pvsa

5032: mmt.transaction_source_id
5033: FROM
5034: mtl_consumption_transactions mct
5035: , mtl_material_transactions mmt
5036: , po_vendor_sites_all pvsa
5037: WHERE mct.transaction_id = mmt.transaction_id
5038: AND mmt.owning_organization_id = pvsa.vendor_site_id
5039: AND pvsa.vendor_id = '|| p_vendor_id ||
5040: --' AND mct.consumption_processed_flag <> ''Y''

Line 5058: , po_vendor_sites_all pvsa

5054: mmt.transaction_source_id
5055: FROM
5056: mtl_consumption_transactions mct
5057: , mtl_material_transactions mmt
5058: , po_vendor_sites_all pvsa
5059: WHERE mct.transaction_id = mmt.transaction_id
5060: AND mmt.owning_organization_id = pvsa.vendor_site_id
5061: AND pvsa.vendor_id = ' || p_vendor_id ||
5062: --' AND mct.consumption_processed_flag <> ''Y''

Line 5079: , po_vendor_sites_all pvsa

5075: mmt.transaction_source_id
5076: FROM
5077: mtl_consumption_transactions mct
5078: , mtl_material_transactions mmt
5079: , po_vendor_sites_all pvsa
5080: WHERE mct.transaction_id = mmt.transaction_id
5081: AND mmt.owning_organization_id = pvsa.vendor_site_id
5082: AND pvsa.vendor_id = '|| p_vendor_id ||
5083: --' AND mct.consumption_processed_flag <> ''Y''

Line 5100: , po_vendor_sites_all pvsa

5096: mmt.transaction_source_id
5097: FROM
5098: mtl_consumption_transactions mct
5099: , mtl_material_transactions mmt
5100: , po_vendor_sites_all pvsa
5101: WHERE mct.transaction_id = mmt.transaction_id
5102: AND mmt.owning_organization_id = pvsa.vendor_site_id
5103: AND pvsa.vendor_id = '|| p_vendor_id ||
5104: --' AND mct.consumption_processed_flag <> ''Y''

Line 5120: , po_vendor_sites_all pvsa

5116: mmt.transaction_source_id
5117: FROM
5118: mtl_consumption_transactions mct
5119: , mtl_material_transactions mmt
5120: , po_vendor_sites_all pvsa
5121: WHERE mct.transaction_id = mmt.transaction_id
5122: AND mmt.owning_organization_id = pvsa.vendor_site_id
5123: AND pvsa.vendor_id = '|| p_vendor_id ||
5124: --' AND mct.consumption_processed_flag <> ''Y''

Line 5141: , po_vendor_sites_all pvsa

5137: mmt.transaction_source_id
5138: FROM
5139: mtl_consumption_transactions mct
5140: , mtl_material_transactions mmt
5141: , po_vendor_sites_all pvsa
5142: WHERE mct.transaction_id = mmt.transaction_id
5143: AND mmt.owning_organization_id = pvsa.vendor_site_id
5144: AND pvsa.vendor_id = '|| p_vendor_id ||
5145: --' AND mct.consumption_processed_flag <> ''Y''

Line 5161: , po_vendor_sites_all pvsa

5157: mmt.transaction_source_id
5158: FROM
5159: mtl_consumption_transactions mct
5160: , mtl_material_transactions mmt
5161: , po_vendor_sites_all pvsa
5162: WHERE mct.transaction_id = mmt.transaction_id
5163: AND mmt.owning_organization_id = pvsa.vendor_site_id
5164: AND pvsa.vendor_id = '|| p_vendor_id ||
5165: --' AND mct.consumption_processed_flag <> ''Y''

Line 5181: , po_vendor_sites_all pvsa

5177: mmt.transaction_source_id
5178: FROM
5179: mtl_consumption_transactions mct
5180: , mtl_material_transactions mmt
5181: , po_vendor_sites_all pvsa
5182: WHERE mct.transaction_id = mmt.transaction_id
5183: AND mmt.owning_organization_id = pvsa.vendor_site_id
5184: AND pvsa.vendor_id = '|| p_vendor_id ||
5185: --' AND mct.consumption_processed_flag <> ''Y'' ';