DBA Data[Home] [Help]

APPS.CSTPLVCP dependencies on WIP_FLOW_SCHEDULES

Line 866: wip_flow_schedules wfs,

862: 3, 0,
863: 4, decode(i_exp_flag, 1, 1, 0))
864: into l_exp_flag
865: from mtl_material_transactions mmt,
866: wip_flow_schedules wfs,
867: wip_accounting_classes wac
868: where mmt.transaction_id = i_txn_id
869: and mmt.organization_id = i_org_id
870: and wfs.organization_id = i_org_id

Line 3091: -- cfm then use wip_flow_schedules

3087: l_stmt_num := 50;
3088:
3089: if (i_citw_flag = 1) then
3090: if(i_flow_schedule = 1) then
3091: -- cfm then use wip_flow_schedules
3092: -- class_type 1 and 3 : asset job, 4 : exp job
3093: select decode(wac.class_type, 1, 0,
3094: 3, 0,
3095: 4, decode(l_exp1, 1, 1, 0))

Line 3098: wip_flow_schedules wfs,

3094: 3, 0,
3095: 4, decode(l_exp1, 1, 1, 0))
3096: into l_exp2
3097: from mtl_material_transactions mmt,
3098: wip_flow_schedules wfs,
3099: wip_accounting_classes wac
3100: where mmt.transaction_id = i_txn_id
3101: and mmt.organization_id = i_org_id
3102: and wfs.organization_id = i_org_id