DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on CST_CG_WIP_ACCT_CLASSES_V

Line 3725: from cst_cg_wip_acct_classes_v ccwac,mtl_parameters mp

3721:
3722: select 1 into l_dummy
3723: from
3724: ( SELECT DISTINCT ccwac.class_code
3725: from cst_cg_wip_acct_classes_v ccwac,mtl_parameters mp
3726: where ccwac.class_code = wjsi_row.class_code
3727: and ccwac.organization_id = wjsi_row.organization_id
3728: and ccwac.class_type = wip_constants.discrete
3729: AND ccwac.organization_id=mp.organization_id

Line 3732: FROM cst_cg_wip_acct_classes_v ccwac2 ,mtl_parameters mp

3728: and ccwac.class_type = wip_constants.discrete
3729: AND ccwac.organization_id=mp.organization_id
3730: AND ( not exists
3731: (SELECT 1
3732: FROM cst_cg_wip_acct_classes_v ccwac2 ,mtl_parameters mp
3733: WHERE mp.organization_id=wjsi_row.organization_id
3734: AND ccwac2.cost_group_id = mp.default_cost_group_id
3735: AND ccwac2.organization_id = mp.organization_id
3736: AND ccwac2.class_type=wip_constants.discrete

Line 3744: from cst_cg_wip_acct_classes_v ccwac,

3740: else
3741: select 1 into l_dummy
3742: from dual
3743: where exists(select 1
3744: from cst_cg_wip_acct_classes_v ccwac,
3745: mtl_parameters mp
3746: where ccwac.class_code = wjsi_row.class_code
3747: and ccwac.organization_id = wjsi_row.organization_id
3748: and ccwac.class_type = wip_constants.discrete