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.WMS_CATCH_WEIGHT_PVT dependencies on INV_GLOBALS

Line 1086: l_txn_action_id := inv_globals.g_action_issue;

1082: END IF;
1083:
1084: IF p_ctwt_adj_type = 'ISSUE' THEN
1085: l_txn_type_id := 1009;
1086: l_txn_action_id := inv_globals.g_action_issue;
1087: ELSIF p_ctwt_adj_type = 'RECEIPT' THEN
1088: l_txn_type_id := 1008;
1089: l_txn_action_id := inv_globals.g_action_receipt;
1090: ELSE

Line 1089: l_txn_action_id := inv_globals.g_action_receipt;

1085: l_txn_type_id := 1009;
1086: l_txn_action_id := inv_globals.g_action_issue;
1087: ELSIF p_ctwt_adj_type = 'RECEIPT' THEN
1088: l_txn_type_id := 1008;
1089: l_txn_action_id := inv_globals.g_action_receipt;
1090: ELSE
1091: IF (l_debug = 1) THEN
1092: print_debug('Unknown adjustment type: ' || p_ctwt_adj_type, 4);
1093: END IF;

Line 1096: l_txn_src_typ_id := inv_globals.g_sourcetype_inventory;

1092: print_debug('Unknown adjustment type: ' || p_ctwt_adj_type, 4);
1093: END IF;
1094: RAISE fnd_api.g_exc_unexpected_error;
1095: END IF;
1096: l_txn_src_typ_id := inv_globals.g_sourcetype_inventory;
1097:
1098: SELECT cat_wt_account
1099: INTO l_adj_account_id
1100: FROM mtl_parameters

Line 3331: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

3327: FROM mtl_material_transactions_temp
3328: WHERE organization_id = p_organization_id
3329: AND inventory_item_id = p_inventory_item_id
3330: AND NVL(revision, '@') = NVL(p_revision, '@')
3331: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
3332: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
3333: AND NVL(content_lpn_id, transfer_lpn_id) = p_lpn_id;
3334:
3335: CURSOR mtlt_cur(p_trx_temp_id NUMBER) IS

Line 3332: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

3328: WHERE organization_id = p_organization_id
3329: AND inventory_item_id = p_inventory_item_id
3330: AND NVL(revision, '@') = NVL(p_revision, '@')
3331: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
3332: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
3333: AND NVL(content_lpn_id, transfer_lpn_id) = p_lpn_id;
3334:
3335: CURSOR mtlt_cur(p_trx_temp_id NUMBER) IS
3336: SELECT rowid, transaction_quantity

Line 3419: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

3415: secondary_uom_code = NULL
3416: WHERE organization_id = p_organization_id
3417: AND inventory_item_id = p_inventory_item_id
3418: AND NVL(revision, '@') = NVL(p_revision, '@')
3419: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
3420: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
3421: AND NVL(content_lpn_id, transfer_lpn_id) = p_lpn_id;
3422: ELSE
3423: FOR mmtt_rec IN mmtt_cur LOOP

Line 3420: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

3416: WHERE organization_id = p_organization_id
3417: AND inventory_item_id = p_inventory_item_id
3418: AND NVL(revision, '@') = NVL(p_revision, '@')
3419: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
3420: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
3421: AND NVL(content_lpn_id, transfer_lpn_id) = p_lpn_id;
3422: ELSE
3423: FOR mmtt_rec IN mmtt_cur LOOP
3424: IF ( l_debug = 1 ) THEN

Line 3476: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

3472: FROM mtl_material_transactions_temp mmtt
3473: WHERE organization_id = p_organization_id
3474: AND inventory_item_id = p_inventory_item_id
3475: AND NVL(revision, '@') = NVL(p_revision, '@')
3476: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
3477: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
3478: AND NVL(content_lpn_id, transfer_lpn_id) = p_lpn_id );
3479: ELSE
3480: FOR mmtt_rec IN mmtt_cur LOOP

Line 3477: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

3473: WHERE organization_id = p_organization_id
3474: AND inventory_item_id = p_inventory_item_id
3475: AND NVL(revision, '@') = NVL(p_revision, '@')
3476: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
3477: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
3478: AND NVL(content_lpn_id, transfer_lpn_id) = p_lpn_id );
3479: ELSE
3480: FOR mmtt_rec IN mmtt_cur LOOP
3481: IF ( l_debug = 1 ) THEN

Line 3610: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

3606: CURSOR mmtt_item_cur IS
3607: SELECT distinct inventory_item_id, organization_id
3608: FROM mtl_material_transactions_temp
3609: WHERE organization_id = p_organization_id
3610: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
3611: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
3612: AND ( transfer_lpn_id = p_outermost_lpn_id OR content_lpn_id = p_outermost_lpn_id )
3613: AND ( secondary_transaction_quantity IS NULL OR secondary_uom_code IS NULL );
3614:

Line 3611: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

3607: SELECT distinct inventory_item_id, organization_id
3608: FROM mtl_material_transactions_temp
3609: WHERE organization_id = p_organization_id
3610: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
3611: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
3612: AND ( transfer_lpn_id = p_outermost_lpn_id OR content_lpn_id = p_outermost_lpn_id )
3613: AND ( secondary_transaction_quantity IS NULL OR secondary_uom_code IS NULL );
3614:
3615: l_return NUMBER := G_CHECK_SUCCESS;

Line 3810: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

3806: SELECT 1
3807: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
3808: WHERE mmtt.organization_id = mmtt_item_rec.organization_id
3809: AND mmtt.inventory_item_id = mmtt_item_rec.inventory_item_id
3810: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
3811: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
3812: AND ( mmtt.transfer_lpn_id = p_outermost_lpn_id OR mmtt.content_lpn_id = p_outermost_lpn_id )
3813: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
3814: AND ( mtlt.secondary_quantity IS NULL OR mtlt.secondary_unit_of_measure IS NULL) );

Line 3811: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

3807: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
3808: WHERE mmtt.organization_id = mmtt_item_rec.organization_id
3809: AND mmtt.inventory_item_id = mmtt_item_rec.inventory_item_id
3810: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
3811: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
3812: AND ( mmtt.transfer_lpn_id = p_outermost_lpn_id OR mmtt.content_lpn_id = p_outermost_lpn_id )
3813: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
3814: AND ( mtlt.secondary_quantity IS NULL OR mtlt.secondary_unit_of_measure IS NULL) );
3815: EXCEPTION