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 526: FROM MTL_MATERIAL_TRANSACTIONS

522:
523: /*
524: AND transaction_id IN
525: (SELECT transaction_id
526: FROM MTL_MATERIAL_TRANSACTIONS
527: WHERE transaction_source_id = p_transaction_source_id
528: AND distribution_account_id = p_accrual_account_id
529: AND owning_organization_id = p_vendor_site_id
530: AND TRUNC(transaction_date) = TRUNC(p_transaction_date)

Line 927: --MTL_MATERIAL_TRANSACTIONS mmt

923: SET mctt.transaction_date =
924: (SELECT
925: TRUNC(MAX(mct.transaction_date))
926: FROM
927: --MTL_MATERIAL_TRANSACTIONS mmt
928: MTL_CONSUMPTION_TRANSACTIONS mct
929: WHERE --mct.transaction_id = mmt.transaction_id AND
930: mct.transaction_source_id = mctt.transaction_source_id
931: AND mct.inventory_item_id = mctt.inventory_item_id

Line 1123: (SELECT transaction_id FROM mtl_material_transactions

1119: AND owning_organization_id = l_owning_organization_id
1120: AND consumption_processed_flag IN ('N','E')
1121: AND batch_id = p_batch_id;
1122: /*WHERE transaction_id IN
1123: (SELECT transaction_id FROM mtl_material_transactions
1124: WHERE transaction_source_id = l_header_id
1125: AND inventory_item_id = l_item_id
1126: AND owning_organization_id = l_owning_organization_id)
1127: AND consumption_processed_flag IN ('N','E')

Line 2558: --, MTL_MATERIAL_TRANSACTIONS mmt

2554: SET (mctt.net_qty,mctt.secondary_net_qty) =
2555: (SELECT SUM(mct.net_qty),SUM(mct.secondary_net_qty)
2556:
2557: FROM MTL_CONSUMPTION_TRANSACTIONS mct
2558: --, MTL_MATERIAL_TRANSACTIONS mmt
2559: WHERE --mmt.transaction_id = mct.transaction_id AND
2560: mct.transaction_source_id = p_txn_source_tab(i)
2561: AND mct.inventory_item_id = p_inventory_item_tab(i)
2562: AND mct.organization_id = p_organization_tab(i)

Line 2734: --, MTL_MATERIAL_TRANSACTIONS mmt

2730: SET (mctt.net_qty,mctt.secondary_net_qty) =
2731: (SELECT SUM(mct.net_qty),SUM(mct.secondary_net_qty)
2732:
2733: FROM MTL_CONSUMPTION_TRANSACTIONS mct
2734: --, MTL_MATERIAL_TRANSACTIONS mmt
2735: WHERE --mmt.transaction_id = mct.transaction_id AND
2736: mct.transaction_source_id = p_txn_source_tab(i)
2737: AND mct.inventory_item_id = p_inventory_item_tab(i)
2738: AND mct.organization_id = p_organization_tab(i)

Line 2785: --, MTL_MATERIAL_TRANSACTIONS mmt

2781: UPDATE/*+ leading(mctt) */ MTL_CONSUMPTION_TXN_TEMP mctt
2782: SET mctt.net_qty =
2783: (SELECT SUM(mct.net_qty)
2784: FROM MTL_CONSUMPTION_TRANSACTIONS mct
2785: --, MTL_MATERIAL_TRANSACTIONS mmt
2786: WHERE --mmt.transaction_id = mct.transaction_id AND
2787: mct.transaction_source_id = p_txn_source_tab(i)
2788: AND mct.inventory_item_id = p_inventory_item_tab(i)
2789: AND mct.organization_id = p_organization_tab(i)

Line 3138: type t_transaction_id IS TABLE OF mTL_material_TRANSACTIONS.transaction_id%type;

3134: PROCEDURE populate_po_line_id
3135: IS
3136:
3137: --declare the variable types for bulk collect
3138: type t_transaction_id IS TABLE OF mTL_material_TRANSACTIONS.transaction_id%type;
3139: type t_transaction_source_id IS TABLE OF mTL_material_TRANSACTIONS.transaction_source_id%type;
3140: type t_inventory_item_id IS TABLE OF mTL_material_TRANSACTIONS.inventory_item_id%type;
3141: type t_item_revision IS TABLE OF mTL_material_TRANSACTIONS.revision%type;
3142: type t_OWNING_ORGANIZATION_ID IS TABLE OF mTL_material_TRANSACTIONS.OWNING_ORGANIZATION_ID%type;

Line 3139: type t_transaction_source_id IS TABLE OF mTL_material_TRANSACTIONS.transaction_source_id%type;

3135: IS
3136:
3137: --declare the variable types for bulk collect
3138: type t_transaction_id IS TABLE OF mTL_material_TRANSACTIONS.transaction_id%type;
3139: type t_transaction_source_id IS TABLE OF mTL_material_TRANSACTIONS.transaction_source_id%type;
3140: type t_inventory_item_id IS TABLE OF mTL_material_TRANSACTIONS.inventory_item_id%type;
3141: type t_item_revision IS TABLE OF mTL_material_TRANSACTIONS.revision%type;
3142: type t_OWNING_ORGANIZATION_ID IS TABLE OF mTL_material_TRANSACTIONS.OWNING_ORGANIZATION_ID%type;
3143: type t_organization_id IS TABLE OF mTL_material_TRANSACTIONS.organization_id%type;

Line 3140: type t_inventory_item_id IS TABLE OF mTL_material_TRANSACTIONS.inventory_item_id%type;

3136:
3137: --declare the variable types for bulk collect
3138: type t_transaction_id IS TABLE OF mTL_material_TRANSACTIONS.transaction_id%type;
3139: type t_transaction_source_id IS TABLE OF mTL_material_TRANSACTIONS.transaction_source_id%type;
3140: type t_inventory_item_id IS TABLE OF mTL_material_TRANSACTIONS.inventory_item_id%type;
3141: type t_item_revision IS TABLE OF mTL_material_TRANSACTIONS.revision%type;
3142: type t_OWNING_ORGANIZATION_ID IS TABLE OF mTL_material_TRANSACTIONS.OWNING_ORGANIZATION_ID%type;
3143: type t_organization_id IS TABLE OF mTL_material_TRANSACTIONS.organization_id%type;
3144: type t_transaction_date IS TABLE OF mTL_material_TRANSACTIONS.transaction_date%type;

Line 3141: type t_item_revision IS TABLE OF mTL_material_TRANSACTIONS.revision%type;

3137: --declare the variable types for bulk collect
3138: type t_transaction_id IS TABLE OF mTL_material_TRANSACTIONS.transaction_id%type;
3139: type t_transaction_source_id IS TABLE OF mTL_material_TRANSACTIONS.transaction_source_id%type;
3140: type t_inventory_item_id IS TABLE OF mTL_material_TRANSACTIONS.inventory_item_id%type;
3141: type t_item_revision IS TABLE OF mTL_material_TRANSACTIONS.revision%type;
3142: type t_OWNING_ORGANIZATION_ID IS TABLE OF mTL_material_TRANSACTIONS.OWNING_ORGANIZATION_ID%type;
3143: type t_organization_id IS TABLE OF mTL_material_TRANSACTIONS.organization_id%type;
3144: type t_transaction_date IS TABLE OF mTL_material_TRANSACTIONS.transaction_date%type;
3145:

Line 3142: type t_OWNING_ORGANIZATION_ID IS TABLE OF mTL_material_TRANSACTIONS.OWNING_ORGANIZATION_ID%type;

3138: type t_transaction_id IS TABLE OF mTL_material_TRANSACTIONS.transaction_id%type;
3139: type t_transaction_source_id IS TABLE OF mTL_material_TRANSACTIONS.transaction_source_id%type;
3140: type t_inventory_item_id IS TABLE OF mTL_material_TRANSACTIONS.inventory_item_id%type;
3141: type t_item_revision IS TABLE OF mTL_material_TRANSACTIONS.revision%type;
3142: type t_OWNING_ORGANIZATION_ID IS TABLE OF mTL_material_TRANSACTIONS.OWNING_ORGANIZATION_ID%type;
3143: type t_organization_id IS TABLE OF mTL_material_TRANSACTIONS.organization_id%type;
3144: type t_transaction_date IS TABLE OF mTL_material_TRANSACTIONS.transaction_date%type;
3145:
3146: --declare the local variables

Line 3143: type t_organization_id IS TABLE OF mTL_material_TRANSACTIONS.organization_id%type;

3139: type t_transaction_source_id IS TABLE OF mTL_material_TRANSACTIONS.transaction_source_id%type;
3140: type t_inventory_item_id IS TABLE OF mTL_material_TRANSACTIONS.inventory_item_id%type;
3141: type t_item_revision IS TABLE OF mTL_material_TRANSACTIONS.revision%type;
3142: type t_OWNING_ORGANIZATION_ID IS TABLE OF mTL_material_TRANSACTIONS.OWNING_ORGANIZATION_ID%type;
3143: type t_organization_id IS TABLE OF mTL_material_TRANSACTIONS.organization_id%type;
3144: type t_transaction_date IS TABLE OF mTL_material_TRANSACTIONS.transaction_date%type;
3145:
3146: --declare the local variables
3147: l_transaction_id t_transaction_id;

Line 3144: type t_transaction_date IS TABLE OF mTL_material_TRANSACTIONS.transaction_date%type;

3140: type t_inventory_item_id IS TABLE OF mTL_material_TRANSACTIONS.inventory_item_id%type;
3141: type t_item_revision IS TABLE OF mTL_material_TRANSACTIONS.revision%type;
3142: type t_OWNING_ORGANIZATION_ID IS TABLE OF mTL_material_TRANSACTIONS.OWNING_ORGANIZATION_ID%type;
3143: type t_organization_id IS TABLE OF mTL_material_TRANSACTIONS.organization_id%type;
3144: type t_transaction_date IS TABLE OF mTL_material_TRANSACTIONS.transaction_date%type;
3145:
3146: --declare the local variables
3147: l_transaction_id t_transaction_id;
3148: l_transaction_source_id t_transaction_source_id;

Line 3167: MTL_MATERIAL_TRANSACTIONS mmt

3163: mmt.OWNING_ORGANIZATION_ID ,
3164: mmt.ORGANIZATION_ID ,
3165: mmt.TRANSACTION_DATE
3166: FROM MTL_CONSUMPTION_TRANSACTIONS mct ,
3167: MTL_MATERIAL_TRANSACTIONS mmt
3168: WHERE mmt.transaction_id = mct.transaction_id
3169: AND consumption_processed_flag IN ( 'N',
3170: 'E')
3171: AND PO_LINE_ID IS NULL ;

Line 4566: and exists(select /+ no_unnest / 1 from MTL_MATERIAL_TRANSACTIONS mmt

4562: select 1 into l_count from dual
4563: where exists(select /*+ no_unnest */ 1 from MTL_CONSUMPTION_TRANSACTIONS mct
4564: where consumption_processed_flag IN ('N', 'E')
4565: AND ( mct.batch_id = l_batch_id OR mct.batch_id IS NULL) AND NVL(net_qty,0) > 0
4566: and exists(select /*+ no_unnest */ 1 from MTL_MATERIAL_TRANSACTIONS mmt
4567: where mct.transaction_id = mmt.transaction_id
4568: AND mmt.owning_organization_id = NVL(p_vendor_site_id, mmt.owning_organization_id)
4569: AND mmt.organization_id = NVL(p_organization_id, mmt.organization_id)
4570: AND mmt.inventory_item_id = NVL(p_inventory_item_id, mmt.inventory_item_id)

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 =