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.

[Home] [Help]

APPS.CST_MGD_MSTR_BOOK_RPT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 702: FROM mtl_material_transactions

698: BEGIN
699: BEGIN
700: SELECT shipment_number
701: INTO lv_shipment_num
702: FROM mtl_material_transactions
703: WHERE transaction_id = p_transaction_id;
704:
705: EXCEPTION
706: WHEN OTHERS THEN

Line 730: FROM mtl_material_transactions

726: BEGIN
727: BEGIN
728: SELECT waybill_airbill
729: INTO lc_waybill_airbill
730: FROM mtl_material_transactions
731: WHERE transaction_id = p_transaction_id;
732: EXCEPTION
733: WHEN OTHERS THEN
734: lc_waybill_airbill := NULL;

Line 771: FROM mtl_material_transactions MMT

767: INTO ln_org_id
768: ,ln_trans_source_type_id
769: ,ln_trans_source_id
770: ,ln_trx_line_id
771: FROM mtl_material_transactions MMT
772: WHERE MMT.transaction_id = p_transaction_id;
773:
774: IF ln_trans_source_type_id = 1 THEN
775: SELECT PHA.segment1

Line 798: -- FROM mtl_material_transactions

794: /* ppandit Comment start - Commented by ppandit for Italy and China JF Project */
795: --BEGIN
796: -- SELECT transaction_source_name
797: -- INTO lv_po_number
798: -- FROM mtl_material_transactions
799: -- WHERE transaction_id =p_transaction_id;
800: --EXCEPTION
801: -- WHEN others THEN
802: -- lv_po_number:=NULL;

Line 1864: FROM mtl_material_transactions MMT

1860: lc_transaction_action VARCHAR2 (80);
1861: BEGIN
1862: SELECT MLS.meaning
1863: INTO lc_transaction_action
1864: FROM mtl_material_transactions MMT
1865: ,mfg_lookups MLS
1866: WHERE MLS.lookup_code = MMT.transaction_action_id
1867: AND MLS.lookup_type = 'MTL_TRANSACTION_ACTION'
1868: AND MMT.transaction_id = p_transaction_id;

Line 2242: FROM mtl_material_transactions mmt

2238: mmt.percentage_change percentage_change,
2239: mmt.transfer_organization_id transfer_organization_id,
2240: mmt.creation_date creation_date, mmt.quantity_adjusted,
2241: NVL (mmt.subinventory_code, ' ') subinventory_code, mmt.organization_id subinventory_org_id
2242: FROM mtl_material_transactions mmt
2243: WHERE mmt.organization_id = p_org_id
2244: AND mmt.inventory_item_id = p_item_id
2245: AND NVL (mmt.acct_period_id, 0) =
2246: NVL (p_acct_period_id, NVL (mmt.acct_period_id, 0))

Line 2263: FROM mtl_material_transactions mmt1

2259: AND asset_inventory = 1)
2260: )
2261: AND mmt.transaction_id NOT IN (
2262: SELECT mmt1.transaction_id
2263: FROM mtl_material_transactions mmt1
2264: WHERE mmt1.organization_id = p_org_id
2265: AND mmt1.inventory_item_id = p_item_id
2266: AND NVL (mmt1.acct_period_id, 0) =
2267: NVL (p_acct_period_id, NVL (mmt1.acct_period_id, 0))

Line 2720: ,mtl_material_transactions MTX ';

2716:
2717: v_from_clause := ' FROM mtl_system_items_b MSI
2718: ,gl_sets_of_books GSOB
2719: ,org_organization_definitions OOD
2720: ,mtl_material_transactions MTX ';
2721:
2722: v_where_clause := ' WHERE MSI.organization_id = ' || p_org_id ||
2723: ' AND OOD.organization_id = MSI.organization_id
2724: AND OOD.set_of_books_id = GSOB.set_of_books_id

Line 2940: FROM mtl_material_transactions mmt

2936: -- owning_tp_type will be 1 for consigned transaction
2937: -- bug#3118846 fix: exclude TRX from NON Qty tracked subinventories
2938: SELECT NVL (SUM (mmt.primary_quantity), 0)
2939: INTO l_item_trx_qty
2940: FROM mtl_material_transactions mmt
2941: WHERE mmt.organization_id = p_org_id
2942: AND mmt.inventory_item_id = l_item_id
2943: AND mmt.subinventory_code BETWEEN NVL (p_subinv_from,
2944: mmt.subinventory_code)

Line 2957: FROM mtl_material_transactions mmt1

2953: AND asset_inventory = 1)
2954: )
2955: AND mmt.transaction_id NOT IN (
2956: SELECT mmt1.transaction_id
2957: FROM mtl_material_transactions mmt1
2958: WHERE mmt1.organization_id = p_org_id
2959: AND mmt1.inventory_item_id = l_item_id
2960: AND mmt1.subinventory_code BETWEEN NVL (p_subinv_from,
2961: mmt1.subinventory_code

Line 2992: FROM mtl_material_transactions mmt

2988: BEGIN
2989: -- Bug#2576310 fix subinventory code to add in the WHERE condition
2990: SELECT NVL (mmt.prior_cost, mmt.actual_cost)
2991: INTO l_item_unit_cost
2992: FROM mtl_material_transactions mmt
2993: WHERE mmt.transaction_id =
2994: (SELECT MIN (transaction_id)
2995: FROM mtl_material_transactions
2996: WHERE organization_id = p_org_id

Line 2995: FROM mtl_material_transactions

2991: INTO l_item_unit_cost
2992: FROM mtl_material_transactions mmt
2993: WHERE mmt.transaction_id =
2994: (SELECT MIN (transaction_id)
2995: FROM mtl_material_transactions
2996: WHERE organization_id = p_org_id
2997: AND inventory_item_id = l_item_id
2998: AND transaction_date =
2999: (SELECT MIN (transaction_date)

Line 3000: FROM mtl_material_transactions

2996: WHERE organization_id = p_org_id
2997: AND inventory_item_id = l_item_id
2998: AND transaction_date =
2999: (SELECT MIN (transaction_date)
3000: FROM mtl_material_transactions
3001: WHERE organization_id = p_org_id
3002: AND transaction_action_id NOT IN (24, 30)
3003: AND NVL (owning_tp_type, 2) <> 1
3004: AND transaction_date BETWEEN TO_DATE(p_date_from, 'YYYY/MM/DD HH24:MI:SS')

Line 3024: FROM mtl_material_transactions mmt1

3020: AND asset_inventory = 1)
3021: )
3022: AND mmt.transaction_id NOT IN (
3023: SELECT mmt1.transaction_id
3024: FROM mtl_material_transactions mmt1
3025: WHERE mmt1.organization_id = p_org_id
3026: AND mmt1.inventory_item_id = l_item_id
3027: AND NVL (mmt1.owning_tp_type, 2) = 1
3028: AND mmt1.transaction_date BETWEEN TO_DATE(p_date_from, 'YYYY/MM/DD HH24:MI:SS') AND TO_DATE(p_date_to, 'YYYY/MM/DD HH24:MI:SS') + (86399 / 86400) -- Changed by ppandit for using params directly, Italy China Enhancements