DBA Data[Home] [Help]

APPS.INV_COPY_ORGANIZATION_REPORT dependencies on CST_RESOURCE_OVERHEADS

Line 3756: FROM CST_RESOURCE_OVERHEADS crh1

3752: IS
3753: SELECT br1.RESOURCE_CODE
3754: , cct1.COST_TYPE
3755: , br2.RESOURCE_CODE
3756: FROM CST_RESOURCE_OVERHEADS crh1
3757: , CST_COST_TYPES cct1
3758: , BOM_RESOURCES br1
3759: , BOM_RESOURCES br2
3760: WHERE crh1.ORGANIZATION_ID = p_model_org_id

Line 3765: FROM CST_RESOURCE_OVERHEADS crh2

3761: AND br1.RESOURCE_ID = crh1.RESOURCE_ID
3762: AND br2.RESOURCE_ID = crh1.OVERHEAD_ID
3763: AND cct1.COST_TYPE_ID = crh1.COST_TYPE_ID
3764: AND NOT EXISTS ( SELECT 'x'
3765: FROM CST_RESOURCE_OVERHEADS crh2
3766: , CST_COST_TYPES cct2
3767: , BOM_RESOURCES br3
3768: WHERE crh2.ORGANIZATION_ID = p_organization_id
3769: AND br3.RESOURCE_ID = crh2.RESOURCE_ID

Line 3778: FROM CST_RESOURCE_OVERHEADS crh

3774:
3775: CURSOR l_cnt_csr ( p_org_id NUMBER )
3776: IS
3777: SELECT COUNT(crh.RESOURCE_ID)
3778: FROM CST_RESOURCE_OVERHEADS crh
3779: WHERE crh.ORGANIZATION_ID = p_org_id;
3780:
3781: BEGIN
3782: