APPS.INV_DIAG_DTXN dependencies on INV_DIAG_GRP

Line 77: row_limit :=INV_DIAG_GRP.g_max_row;

73: -- accept input
74: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
75: l_script :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ScriptName',inputs);
76: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
77: row_limit :=INV_DIAG_GRP.g_max_row;
78:
79: if l_script = 'acct_period' then
80:
81: sqltxt := 'SELECT organization_code || '' ('' ||mmt.organization_id|| '')'' "Organization|Code (Id)" '||

Line 201: ' ,INV_DIAG_GRP.CHECK_ONHAND(mti.inventory_item_id, mti.organization_id,mti.revision,mti.subinventory_code,mti.locator_id) onhand '||

197: ',rev,sub,onhand,qty_avail,transaction_quantity '||
198: 'from '||
199: ' (select mti.organization_id ,mti.inventory_item_id ,mti.revision rev, '||
200: ' mti.subinventory_code sub '||
201: ' ,INV_DIAG_GRP.CHECK_ONHAND(mti.inventory_item_id, mti.organization_id,mti.revision,mti.subinventory_code,mti.locator_id) onhand '||
202: ' ,INV_DIAG_GRP.CHECK_AVAIL(mti.inventory_item_id,mti.organization_id ,mti.revision ,mti.subinventory_code,mti.locator_id) qty_avail '||
203: ' ,transaction_quantity '||
204: ' from mtl_transactions_interface mti '||
205: ' group by mti.inventory_item_id,mti.organization_id,mti.revision, '||

Line 202: ' ,INV_DIAG_GRP.CHECK_AVAIL(mti.inventory_item_id,mti.organization_id ,mti.revision ,mti.subinventory_code,mti.locator_id) qty_avail '||

198: 'from '||
199: ' (select mti.organization_id ,mti.inventory_item_id ,mti.revision rev, '||
200: ' mti.subinventory_code sub '||
201: ' ,INV_DIAG_GRP.CHECK_ONHAND(mti.inventory_item_id, mti.organization_id,mti.revision,mti.subinventory_code,mti.locator_id) onhand '||
202: ' ,INV_DIAG_GRP.CHECK_AVAIL(mti.inventory_item_id,mti.organization_id ,mti.revision ,mti.subinventory_code,mti.locator_id) qty_avail '||
203: ' ,transaction_quantity '||
204: ' from mtl_transactions_interface mti '||
205: ' group by mti.inventory_item_id,mti.organization_id,mti.revision, '||
206: ' mti.subinventory_code,mti.locator_id,transaction_quantity '||

Line 226: ' ,INV_DIAG_GRP.CHECK_ONHAND(mti.inventory_item_id, mti.organization_id,mti.revision,mti.subinventory_code,mti.locator_id) onhand '||

222: ',rev,sub,onhand,qty_avail,transaction_quantity '||
223: 'from '||
224: ' (select mti.organization_id ,mti.inventory_item_id ,mti.revision rev, '||
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, '||

Line 227: ' ,INV_DIAG_GRP.CHECK_AVAIL(mti.inventory_item_id,mti.organization_id ,mti.revision ,mti.subinventory_code,mti.locator_id) qty_avail '||

223: 'from '||
224: ' (select mti.organization_id ,mti.inventory_item_id ,mti.revision rev, '||
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 '||