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 MTL_MATERIAL_TRANSACTIONS

Line 183: --MTL_MATERIAL_TRANSACTIONS mmt,

179: SELECT pod.po_distribution_id
180: INTO l_po_distribution_id
181: FROM
182: MTL_CONSUMPTION_TRANSACTIONS mct,
183: --MTL_MATERIAL_TRANSACTIONS mmt,
184: po_line_locations_all poll,
185: po_distributions_all pod,
186: po_lines_all pol
187: WHERE mct.transaction_id = l_transaction_id

Line 226: --MTL_MATERIAL_TRANSACTIONS mmt,

222: SELECT pod.po_distribution_id
223: INTO l_po_distribution_id
224: FROM
225: MTL_CONSUMPTION_TRANSACTIONS mct,
226: --MTL_MATERIAL_TRANSACTIONS mmt,
227: po_line_locations_all poll,
228: po_distributions_all pod,
229: po_lines_all pol
230: WHERE mct.transaction_id = l_transaction_id

Line 502: FROM MTL_MATERIAL_TRANSACTIONS

498: AND ((NVL(mct.global_agreement_flag,'N') = 'Y'
499: AND TRUNC(mct.transaction_date) = TRUNC(p_transaction_date))
500: OR (NVL(mct.global_agreement_flag,'N') = 'N'));
501: /* (SELECT transaction_id
502: FROM MTL_MATERIAL_TRANSACTIONS
503: WHERE transaction_source_id = p_transaction_source_id
504: AND distribution_account_id = p_accrual_account_id
505: AND owning_organization_id = p_vendor_site_id
506: AND TRUNC(transaction_date) = TRUNC(p_transaction_date)

Line 531: FROM MTL_MATERIAL_TRANSACTIONS

527: AND mct.owning_organization_id = p_vendor_site_id;
528: /*
529: AND transaction_id IN
530: (SELECT transaction_id
531: FROM MTL_MATERIAL_TRANSACTIONS
532: WHERE transaction_source_id = p_transaction_source_id
533: AND owning_organization_id = p_vendor_site_id
534: AND distribution_account_id = p_accrual_account_id
535: AND inventory_item_id IN

Line 563: FROM MTL_MATERIAL_TRANSACTIONS

559:
560: /*
561: AND transaction_id IN
562: (SELECT transaction_id
563: FROM MTL_MATERIAL_TRANSACTIONS
564: WHERE transaction_source_id = p_transaction_source_id
565: AND distribution_account_id = p_accrual_account_id
566: AND owning_organization_id = p_vendor_site_id
567: AND TRUNC(transaction_date) = TRUNC(p_transaction_date)

Line 744: , MTL_MATERIAL_TRANSACTIONS mmt

740: , TRUNC(mmt.transaction_date)
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)

Line 954: , MTL_MATERIAL_TRANSACTIONS mmt

950: , TRUNC(mmt.transaction_date)
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)

Line 1017: , MTL_MATERIAL_TRANSACTIONS mmt

1013: , NVL(mct.rate,-1)
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)

Line 1109: -- --MTL_MATERIAL_TRANSACTIONS mmt

1105: --SET mctt.transaction_date =
1106: -- (SELECT
1107: -- TRUNC(MAX(mct.transaction_date))
1108: -- FROM
1109: -- --MTL_MATERIAL_TRANSACTIONS mmt
1110: -- MTL_CONSUMPTION_TRANSACTIONS mct
1111: -- WHERE --mct.transaction_id = mmt.transaction_id AND
1112: -- mct.transaction_source_id = mctt.transaction_source_id
1113: -- AND mct.inventory_item_id = mctt.inventory_item_id

Line 1138: --MTL_MATERIAL_TRANSACTIONS mmt

1134: SET mctt.transaction_date =
1135: (SELECT
1136: TRUNC(MAX(mct.transaction_date))
1137: FROM
1138: --MTL_MATERIAL_TRANSACTIONS mmt
1139: MTL_CONSUMPTION_TRANSACTIONS mct
1140: WHERE --mct.transaction_id = mmt.transaction_id AND
1141: mct.transaction_source_id = mctt.transaction_source_id
1142: AND mct.inventory_item_id = mctt.inventory_item_id

Line 1328: (SELECT transaction_id FROM mtl_material_transactions

1324: AND owning_organization_id = l_owning_organization_id
1325: AND consumption_processed_flag IN ('N','E')
1326: AND batch_id = p_batch_id;
1327: /*WHERE transaction_id IN
1328: (SELECT transaction_id FROM mtl_material_transactions
1329: WHERE transaction_source_id = l_header_id
1330: AND inventory_item_id = l_item_id
1331: AND owning_organization_id = l_owning_organization_id)
1332: AND consumption_processed_flag IN ('N','E')

Line 2844: --, MTL_MATERIAL_TRANSACTIONS mmt

2840: SET (mctt.net_qty,mctt.secondary_net_qty) =
2841: (SELECT SUM(mct.net_qty),SUM(mct.secondary_net_qty)
2842:
2843: FROM MTL_CONSUMPTION_TRANSACTIONS mct
2844: --, MTL_MATERIAL_TRANSACTIONS mmt
2845: WHERE --mmt.transaction_id = mct.transaction_id AND
2846: mct.transaction_source_id = p_txn_source_tab(i)
2847: AND mct.inventory_item_id = p_inventory_item_tab(i)
2848: AND mct.organization_id = p_organization_tab(i)

Line 3018: --, MTL_MATERIAL_TRANSACTIONS mmt

3014: SET (mctt.net_qty,mctt.secondary_net_qty) =
3015: (SELECT SUM(mct.net_qty),SUM(mct.secondary_net_qty)
3016:
3017: FROM MTL_CONSUMPTION_TRANSACTIONS mct
3018: --, MTL_MATERIAL_TRANSACTIONS mmt
3019: WHERE --mmt.transaction_id = mct.transaction_id AND
3020: mct.transaction_source_id = p_txn_source_tab(i)
3021: AND mct.inventory_item_id = p_inventory_item_tab(i)
3022: AND mct.organization_id = p_organization_tab(i)

Line 3067: --, MTL_MATERIAL_TRANSACTIONS mmt

3063: UPDATE/*+ leading(mctt) */ MTL_CONSUMPTION_TXN_TEMP mctt
3064: SET mctt.net_qty =
3065: (SELECT SUM(mct.net_qty)
3066: FROM MTL_CONSUMPTION_TRANSACTIONS mct
3067: --, MTL_MATERIAL_TRANSACTIONS mmt
3068: WHERE --mmt.transaction_id = mct.transaction_id AND
3069: mct.transaction_source_id = p_txn_source_tab(i)
3070: AND mct.inventory_item_id = p_inventory_item_tab(i)
3071: AND mct.organization_id = p_organization_tab(i)

Line 4467: mtl_material_transactions mmt

4463: WHERE mct.transaction_id IN
4464: (SELECT
4465: mmt.transaction_id
4466: FROM
4467: mtl_material_transactions mmt
4468: WHERE mmt.transaction_source_id = l_txn_source_tab(i)
4469: AND mmt.inventory_item_id = l_item_tab(i)
4470: AND mmt.organization_id = l_org_tab(i)
4471: /* Bug 4969421 Starts here*/

Line 4517: MTL_MATERIAL_TRANSACTIONS mmt

4513: /* WHERE mct.transaction_id IN
4514: (SELECT
4515: mmt.transaction_id
4516: FROM
4517: MTL_MATERIAL_TRANSACTIONS mmt
4518: WHERE mmt.transaction_source_id = l_txn_source_tab(i)
4519: AND mmt.inventory_item_id = l_item_tab(i)
4520: AND mmt.organization_id = l_org_tab(i)
4521: --AND mmt.transaction_cost = l_price_tab(i)

Line 4803: , MTL_MATERIAL_TRANSACTIONS mmt

4799: INTO
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)

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 4879: , mtl_material_transactions mmt

4875: l_blanket_query := 'SELECT DISTINCT
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''

Line 4900: , mtl_material_transactions mmt

4896: l_blanket_query := 'SELECT DISTINCT
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''

Line 4920: , mtl_material_transactions mmt

4916: l_blanket_query := 'SELECT DISTINCT
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''

Line 4940: , mtl_material_transactions mmt

4936: l_blanket_query := 'SELECT DISTINCT
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''

Line 4959: , mtl_material_transactions mmt

4955: l_blanket_query := 'SELECT DISTINCT
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''

Line 4979: , mtl_material_transactions mmt

4975: l_blanket_query := 'SELECT DISTINCT
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''

Line 4998: , mtl_material_transactions mmt

4994: l_blanket_query := 'SELECT DISTINCT
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''

Line 5017: , mtl_material_transactions mmt

5013: l_blanket_query := 'SELECT DISTINCT
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''

Line 5035: , mtl_material_transactions mmt

5031: l_blanket_query := 'SELECT DISTINCT
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 ||

Line 5057: , mtl_material_transactions mmt

5053: l_blanket_query := 'SELECT DISTINCT
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 ||

Line 5078: , mtl_material_transactions mmt

5074: l_blanket_query := 'SELECT DISTINCT
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 ||

Line 5099: , mtl_material_transactions mmt

5095: l_blanket_query := 'SELECT DISTINCT
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 ||

Line 5119: , mtl_material_transactions mmt

5115: l_blanket_query := 'SELECT DISTINCT
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 ||

Line 5140: , mtl_material_transactions mmt

5136: l_blanket_query := 'SELECT DISTINCT
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 ||

Line 5160: , mtl_material_transactions mmt

5156: l_blanket_query := 'SELECT DISTINCT
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 ||

Line 5180: , mtl_material_transactions mmt

5176: l_blanket_query := 'SELECT DISTINCT
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 ||