APPS.INV_DIAG_DTXN dependencies on MTL_MATERIAL_TRANSACTIONS

Line 36: from mtl_material_transactions

32:
33: cursor c_overshipline is
34: select wdd1.source_line_id from
35: ( select inventory_item_id, trx_source_line_id, organization_id, sum(abs(transaction_quantity)) mmt_qty
36: from mtl_material_transactions
37: where picking_line_id is not null
38: and transaction_source_type_id = 8
39: group by inventory_item_id, trx_source_line_id, organization_id
40: ) mmt ,

Line 100: 'FROM mtl_material_transactions mmt '||

96: ',transfer_locator_id "Transfer Location" '||
97: ',transaction_quantity "Txn Qty" '||
98: ',primary_quantity "Primary Qty" '||
99: ',transaction_uom "Txn UoM" '||
100: 'FROM mtl_material_transactions mmt '||
101: ',mtl_transaction_types mtt '||
102: ',mtl_txn_source_types mtst '||
103: ',mtl_item_flexfields mif '||
104: ',mfg_lookups ml '||

Line 229: ' from mtl_material_transactions_temp mti '||

225: ' mti.subinventory_code sub '||
226: ' ,INV_DIAG_GRP.CHECK_ONHAND(mti.inventory_item_id, mti.organization_id,mti.revision,mti.subinventory_code,mti.locator_id) onhand '||
227: ' ,INV_DIAG_GRP.CHECK_AVAIL(mti.inventory_item_id,mti.organization_id ,mti.revision ,mti.subinventory_code,mti.locator_id) qty_avail '||
228: ' ,transaction_quantity '||
229: ' from mtl_material_transactions_temp mti '||
230: ' group by mti.inventory_item_id,mti.organization_id,mti.revision, '||
231: ' mti.subinventory_code,mti.locator_id,transaction_quantity '||
232: ' order by mti.inventory_item_id) mti '||
233: ', mtl_parameters mp '||

Line 270: ' from mtl_material_transactions '||

266: ',mif.item_number|| '' (''||mmt.inventory_item_id||'')'' "Item (Id)" , '||
267: 'wdd1.source_header_number "Order Number", wdd1.source_line_id "Source line Id", '||
268: 'mmt.mmt_qty "MMT Qty", wdd1.shp_qty "Shp qty",mmt.mmt_qty -wdd1.shp_qty "Diff Qty" FROM '||
269: '( select inventory_item_id, trx_source_line_id, organization_id, sum(abs(transaction_quantity)) mmt_qty '||
270: ' from mtl_material_transactions '||
271: ' where picking_line_id is not null '||
272: ' and transaction_source_type_id = 8 '||
273: ' group by inventory_item_id, trx_source_line_id, organization_id) mmt , '||
274: '( select wdd.source_header_number, wdd.source_line_id, wdd.inventory_item_id, '||

Line 458: 'from mtl_material_transactions mmt '||

454: ', mmt.transfer_transaction_id "Transfer Txn Id" '||
455: ', mmt.transfer_organization_id "Transfer Organization Id" '||
456: ', mmt.transfer_subinventory "Transfer Subinv" '||
457: ', mmt.shipment_number '||
458: 'from mtl_material_transactions mmt '||
459: ', mtl_item_flexfields mif '||
460: ', mtl_transaction_types tt '||
461: ', mtl_txn_source_types st '||
462: ', mfg_lookups ml '||

Line 475: 'mtl_material_transactions '||

471: 'and mmt.transaction_type_id = 50 '||
472: 'and mmt.primary_quantity > 0 '||
473: 'and mmt.transaction_id in ( '||
474: 'select transfer_transaction_id from '||
475: 'mtl_material_transactions '||
476: 'where transaction_Source_type_id=8 '||
477: 'and transaction_action_id=2 '||
478: 'and transaction_type_id=50 '||
479: 'and primary_quantity < 0)';

Line 512: 'from mtl_material_transactions mmt '||

508: ', mmt.transfer_transaction_id "Transfer Txn Id" '||
509: ', mmt.transfer_organization_id "Transfer Organization Id" '||
510: ', mmt.transfer_subinventory "Transfer Subinv" '||
511: ', mmt.shipment_number '||
512: 'from mtl_material_transactions mmt '||
513: ', mtl_item_flexfields mif '||
514: ', mtl_transaction_types tt '||
515: ', mtl_txn_source_types st '||
516: ', mfg_lookups ml '||

Line 536: 'mtl_material_transactions b, mtl_transactions_interface a '||

532:
533: elsif l_script = 'duplicat_txn' then
534: sqltxt :='select a.transaction_interface_id , '||
535: 'a.picking_line_id from '||
536: 'mtl_material_transactions b, mtl_transactions_interface a '||
537: 'where a.picking_line_id = b.picking_line_id '||
538: 'and a.trx_source_line_id = b.trx_source_line_id '||
539: 'and a.inventory_item_id = b.inventory_item_id '||
540: 'and b.transaction_type_id = a.transaction_type_id '||

Line 548: 'mtl_material_transactions_temp b, mtl_transactions_interface a '||

544: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Transactions duplicate in MMT and MTI ');
545:
546: sqltxt :='select a.transaction_interface_id , '||
547: 'a.picking_line_id from '||
548: 'mtl_material_transactions_temp b, mtl_transactions_interface a '||
549: 'where a.picking_line_id = b.picking_line_id '||
550: 'and a.trx_source_line_id = b.trx_source_line_id '||
551: 'and a.inventory_item_id = b.inventory_item_id '||
552: 'and b.transaction_type_id = a.transaction_type_id '||

Line 561: 'mtl_material_transactions b, mtl_material_transactions_temp a '||

557: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Transactions duplicate in MMTT and MTI');
558:
559: sqltxt := 'select a.transaction_temp_id, '||
560: 'a.picking_line_id from '||
561: 'mtl_material_transactions b, mtl_material_transactions_temp a '||
562: 'where a.picking_line_id = b.picking_line_id '||
563: 'and a.trx_source_line_id = b.trx_source_line_id '||
564: 'and a.inventory_item_id = b.inventory_item_id '||
565: 'and b.transaction_type_id = a.transaction_type_id '||

Line 580: ' from mtl_material_transactions a,mtl_material_transactions b , '||

576: ', mp2.organization_code || '' ('' ||mp2.organization_id|| '')'' "Transfer Org Code (Id)" '||
577: ', mtt.transaction_type_name ||'' (''||a.transaction_type_id||'')'' "Txn Type (Id)" '||
578: ',a.costed_flag "Costed flag" '||
579: ',mif.item_number ||'' (''||a.inventory_item_id||'')'' "Item (Id)" '||
580: ' from mtl_material_transactions a,mtl_material_transactions b , '||
581: ' mtl_parameters mp1, '||
582: ' mtl_parameters mp2, '||
583: ' mtl_item_flexfields mif, '||
584: ' mtl_transaction_types mtt '||