APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_COGS_RECOGNITION_TEMP

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

3862:
3863: BEGIN
3864: x_return_status :=0;
3865: --Validate the inventory item id.
3866: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp crtt
3867: WHERE INVENTORY_ITEM_ID IS NOT NULL
3868: AND NOT EXISTS (
3869: SELECT NULL
3870: FROM MTL_SYSTEM_ITEMS MSI

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

3883: x_return_status := -1;
3884: RETURN;
3885: END IF;
3886:
3887: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp
3888:
3889: WHERE INVENTORY_ITEM_ID IS NULL;
3890:
3891: IF l_count <> 0 THEN

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

3901: END IF;
3902: --validate subinventory code.
3903:
3904:
3905: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp crtt
3906:
3907: WHERE TRANSACTION_ACTION_ID NOT IN (24, 30)
3908: AND subinventory_code IS NOT null
3909: AND NOT EXISTS (

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

3928: --Validating restricted subinventories
3929:
3930:
3931:
3932: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp crtt
3933:
3934: where SUBINVENTORY_CODE IS NOT NULL
3935: AND NOT EXISTS (
3936: SELECT NULL

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

3961: x_return_status := -1;
3962: RETURN;
3963: END IF;
3964:
3965: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp crtt
3966:
3967: where transaction_type_id <> 10008
3968: OR transaction_action_id <> 36
3969: OR transaction_source_type_id <>2;

Line 4098: FROM mtl_cogs_recognition_temp crtt

4094: crtt.opm_costed_flag,
4095: crtt.cogs_recognition_percent,
4096: crtt.so_issue_account_type ,
4097: crtt.logical_transaction
4098: FROM mtl_cogs_recognition_temp crtt
4099: ;
4100: x_return_status := 0;
4101: RETURN;
4102: EXCEPTION