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_INVENTORY_ADJUSTMENT dependencies on MTL_ADJUSTMENT_SYNC_TEMP

Line 121: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);

117: IF (p_xml_doc_id is null) THEN
118:
119: if (g_debug = 1) then
120: inv_trx_util_pub.TRACE('xml_doc_id is null', 'INV_INVENTORY_ADJUSTMENT', 9);
121: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
122: end if;
123:
124: insert into mtl_adjustment_sync_temp
125: (TRANSACTION_NUMBER,

Line 124: insert into mtl_adjustment_sync_temp

120: inv_trx_util_pub.TRACE('xml_doc_id is null', 'INV_INVENTORY_ADJUSTMENT', 9);
121: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
122: end if;
123:
124: insert into mtl_adjustment_sync_temp
125: (TRANSACTION_NUMBER,
126: TRANSACTION_DATE,
127: CATEGORY,
128: CATEGORY_ID,

Line 208: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);

204: ELSE
205:
206: if (g_debug = 1) then
207: inv_trx_util_pub.TRACE('xml_doc_id is not null', 'INV_INVENTORY_ADJUSTMENT', 9);
208: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
209: end if;
210:
211: insert into mtl_adjustment_sync_temp
212: (TRANSACTION_NUMBER,

Line 211: insert into mtl_adjustment_sync_temp

207: inv_trx_util_pub.TRACE('xml_doc_id is not null', 'INV_INVENTORY_ADJUSTMENT', 9);
208: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
209: end if;
210:
211: insert into mtl_adjustment_sync_temp
212: (TRANSACTION_NUMBER,
213: TRANSACTION_DATE,
214: CATEGORY,
215: CATEGORY_ID,

Line 305: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);

301: IF (p_xml_doc_id is null) THEN
302:
303: if (g_debug = 1) then
304: inv_trx_util_pub.TRACE('xml_doc_id is null', 'INV_INVENTORY_ADJUSTMENT', 9);
305: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
306: end if;
307:
308: insert into mtl_adjustment_sync_temp
309: (TRANSACTION_NUMBER,

Line 308: insert into mtl_adjustment_sync_temp

304: inv_trx_util_pub.TRACE('xml_doc_id is null', 'INV_INVENTORY_ADJUSTMENT', 9);
305: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
306: end if;
307:
308: insert into mtl_adjustment_sync_temp
309: (TRANSACTION_NUMBER,
310: TRANSACTION_DATE,
311: CATEGORY,
312: CATEGORY_ID,

Line 391: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);

387: ELSE
388:
389: if (g_debug = 1) then
390: inv_trx_util_pub.TRACE('xml_doc_id is not null', 'INV_INVENTORY_ADJUSTMENT', 9);
391: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
392: end if;
393:
394: insert into mtl_adjustment_sync_temp
395: (TRANSACTION_NUMBER,

Line 394: insert into mtl_adjustment_sync_temp

390: inv_trx_util_pub.TRACE('xml_doc_id is not null', 'INV_INVENTORY_ADJUSTMENT', 9);
391: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
392: end if;
393:
394: insert into mtl_adjustment_sync_temp
395: (TRANSACTION_NUMBER,
396: TRANSACTION_DATE,
397: CATEGORY,
398: CATEGORY_ID,

Line 494: from mtl_adjustment_sync_temp

490: WHERE organization_id = p_org_id
491: AND NVL(transaction_extracted, 'N') NOT IN ( 'Y', 'P')
492: AND xml_document_id IS NULL
493: AND transaction_id IN (select transaction_number
494: from mtl_adjustment_sync_temp
495: where entity_id = l_entity_id);
496:
497:
498: COMMIT;

Line 535: from mtl_adjustment_sync_temp

531: WHERE organization_id = p_org_id
532: AND NVL(transaction_extracted, 'N') = 'P'
533: AND xml_document_id IS NULL
534: AND transaction_id IN (select transaction_number
535: from mtl_adjustment_sync_temp
536: where entity_id = l_entity_id);
537:
538: END IF;
539:

Line 581: delete from mtl_adjustment_sync_temp

577: if (g_debug = 1) then
578: inv_trx_util_pub.TRACE('deleting the temp table for entity_id: '||p_entity_id, 'INV_INVENTORY_ADJUSTMENT', 9);
579: end if;
580:
581: delete from mtl_adjustment_sync_temp
582: where entity_id = p_entity_id;
583:
584: commit;
585: