DBA Data[Home] [Help]

APPS.BOM_VALIDATE_OP_SEQ dependencies on BOM_STANDARD_OPERATIONS

Line 2381: FROM BOM_STANDARD_OPERATIONS bso

2377: IS
2378: SELECT 'Std Op Invalid'
2379: FROM DUAL
2380: WHERE NOT EXISTS (SELECT NULL
2381: FROM BOM_STANDARD_OPERATIONS bso
2382: , bom_operational_routings bor
2383: WHERE NVL(bso.operation_type,1 )
2384: = DECODE( p_op_type, FND_API.G_MISS_NUM, 1
2385: , NVL(p_op_type, 1))

Line 2394: FROM BOM_STANDARD_OPERATIONS bso

2390: AND bso.organization_id = p_org_id
2391: AND bso.standard_operation_id = p_std_op_id
2392: UNION
2393: SELECT NULL
2394: FROM BOM_STANDARD_OPERATIONS bso
2395: , ENG_REVISED_ITEMS eri
2396: WHERE NVL(bso.operation_type, 1)
2397: = DECODE( p_op_type, FND_API.G_MISS_NUM, 1
2398: , NVL(p_op_type, 1 ) )