APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_COGS_RECOGNITION_TEMP

Line 3953: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp crtt

3949:
3950: BEGIN
3951: x_return_status :=0;
3952: --Validate the inventory item id.
3953: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp crtt
3954: WHERE INVENTORY_ITEM_ID IS NOT NULL
3955: AND NOT EXISTS (
3956: SELECT NULL
3957: FROM MTL_SYSTEM_ITEMS MSI

Line 3974: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp

3970: x_return_status := -1;
3971: RETURN;
3972: END IF;
3973:
3974: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp
3975:
3976: WHERE INVENTORY_ITEM_ID IS NULL;
3977:
3978: IF l_count <> 0 THEN

Line 3992: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp crtt

3988: END IF;
3989: --validate subinventory code.
3990:
3991:
3992: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp crtt
3993:
3994: WHERE TRANSACTION_ACTION_ID NOT IN (24, 30)
3995: AND subinventory_code IS NOT null
3996: AND NOT EXISTS (

Line 4019: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp crtt

4015: --Validating restricted subinventories
4016:
4017:
4018:
4019: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp crtt
4020:
4021: where SUBINVENTORY_CODE IS NOT NULL
4022: AND NOT EXISTS (
4023: SELECT NULL

Line 4052: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp crtt

4048: x_return_status := -1;
4049: RETURN;
4050: END IF;
4051:
4052: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp crtt
4053:
4054: where transaction_type_id <> 10008
4055: OR transaction_action_id <> 36
4056: OR transaction_source_type_id <>2;

Line 4185: FROM mtl_cogs_recognition_temp crtt

4181: crtt.opm_costed_flag,
4182: crtt.cogs_recognition_percent,
4183: crtt.so_issue_account_type ,
4184: crtt.logical_transaction
4185: FROM mtl_cogs_recognition_temp crtt
4186: ;
4187: x_return_status := 0;
4188: RETURN;
4189: EXCEPTION