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 1000: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

996: FROM mtl_material_transactions_temp
997: WHERE organization_id = p_organization_id
998: AND inventory_item_id = p_inventory_item_id
999: AND NVL(revision, '@') = NVL(p_revision, '@')
1000: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
1001: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
1002: AND NVL(content_lpn_id, transfer_lpn_id) = p_lpn_id;
1003:
1004: CURSOR mtlt_cur(p_trx_temp_id NUMBER) IS

Line 1001: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

997: WHERE organization_id = p_organization_id
998: AND inventory_item_id = p_inventory_item_id
999: AND NVL(revision, '@') = NVL(p_revision, '@')
1000: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
1001: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
1002: AND NVL(content_lpn_id, transfer_lpn_id) = p_lpn_id;
1003:
1004: CURSOR mtlt_cur(p_trx_temp_id NUMBER) IS
1005: SELECT rowid, transaction_quantity

Line 1088: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

1084: secondary_uom_code = NULL
1085: WHERE organization_id = p_organization_id
1086: AND inventory_item_id = p_inventory_item_id
1087: AND NVL(revision, '@') = NVL(p_revision, '@')
1088: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
1089: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
1090: AND NVL(content_lpn_id, transfer_lpn_id) = p_lpn_id;
1091: ELSE
1092: FOR mmtt_rec IN mmtt_cur LOOP

Line 1089: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

1085: WHERE organization_id = p_organization_id
1086: AND inventory_item_id = p_inventory_item_id
1087: AND NVL(revision, '@') = NVL(p_revision, '@')
1088: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
1089: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
1090: AND NVL(content_lpn_id, transfer_lpn_id) = p_lpn_id;
1091: ELSE
1092: FOR mmtt_rec IN mmtt_cur LOOP
1093: IF ( l_debug = 1 ) THEN

Line 1145: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

1141: FROM mtl_material_transactions_temp mmtt
1142: WHERE organization_id = p_organization_id
1143: AND inventory_item_id = p_inventory_item_id
1144: AND NVL(revision, '@') = NVL(p_revision, '@')
1145: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
1146: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
1147: AND NVL(content_lpn_id, transfer_lpn_id) = p_lpn_id );
1148: ELSE
1149: FOR mmtt_rec IN mmtt_cur LOOP

Line 1146: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

1142: WHERE organization_id = p_organization_id
1143: AND inventory_item_id = p_inventory_item_id
1144: AND NVL(revision, '@') = NVL(p_revision, '@')
1145: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
1146: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
1147: AND NVL(content_lpn_id, transfer_lpn_id) = p_lpn_id );
1148: ELSE
1149: FOR mmtt_rec IN mmtt_cur LOOP
1150: IF ( l_debug = 1 ) THEN

Line 1279: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

1275: CURSOR mmtt_item_cur IS
1276: SELECT distinct inventory_item_id, organization_id
1277: FROM mtl_material_transactions_temp
1278: WHERE organization_id = p_organization_id
1279: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
1280: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
1281: AND ( transfer_lpn_id = p_outermost_lpn_id OR content_lpn_id = p_outermost_lpn_id )
1282: AND ( secondary_transaction_quantity IS NULL OR secondary_uom_code IS NULL );
1283:

Line 1280: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

1276: SELECT distinct inventory_item_id, organization_id
1277: FROM mtl_material_transactions_temp
1278: WHERE organization_id = p_organization_id
1279: AND transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
1280: AND transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
1281: AND ( transfer_lpn_id = p_outermost_lpn_id OR content_lpn_id = p_outermost_lpn_id )
1282: AND ( secondary_transaction_quantity IS NULL OR secondary_uom_code IS NULL );
1283:
1284: l_return NUMBER := G_CHECK_SUCCESS;

Line 1479: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

1475: SELECT 1
1476: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1477: WHERE mmtt.organization_id = mmtt_item_rec.organization_id
1478: AND mmtt.inventory_item_id = mmtt_item_rec.inventory_item_id
1479: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
1480: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
1481: AND ( mmtt.transfer_lpn_id = p_outermost_lpn_id OR mmtt.content_lpn_id = p_outermost_lpn_id )
1482: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
1483: AND ( mtlt.secondary_quantity IS NULL OR mtlt.secondary_unit_of_measure IS NULL) );

Line 1480: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

1476: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
1477: WHERE mmtt.organization_id = mmtt_item_rec.organization_id
1478: AND mmtt.inventory_item_id = mmtt_item_rec.inventory_item_id
1479: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
1480: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
1481: AND ( mmtt.transfer_lpn_id = p_outermost_lpn_id OR mmtt.content_lpn_id = p_outermost_lpn_id )
1482: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
1483: AND ( mtlt.secondary_quantity IS NULL OR mtlt.secondary_unit_of_measure IS NULL) );
1484: EXCEPTION