DBA Data[Home] [Help]

APPS.CSTPLVCP dependencies on WIP_FLOW_SCHEDULES

Line 800: wip_flow_schedules wfs,

796: 3, 0,
797: 4, decode(i_exp_flag, 1, 1, 0))
798: into l_exp_flag
799: from mtl_material_transactions mmt,
800: wip_flow_schedules wfs,
801: wip_accounting_classes wac
802: where mmt.transaction_id = i_txn_id
803: and mmt.organization_id = i_org_id
804: and wfs.organization_id = i_org_id

Line 3025: -- cfm then use wip_flow_schedules

3021: l_stmt_num := 50;
3022:
3023: if (i_citw_flag = 1) then
3024: if(i_flow_schedule = 1) then
3025: -- cfm then use wip_flow_schedules
3026: -- class_type 1 and 3 : asset job, 4 : exp job
3027: select decode(wac.class_type, 1, 0,
3028: 3, 0,
3029: 4, decode(l_exp1, 1, 1, 0))

Line 3032: wip_flow_schedules wfs,

3028: 3, 0,
3029: 4, decode(l_exp1, 1, 1, 0))
3030: into l_exp2
3031: from mtl_material_transactions mmt,
3032: wip_flow_schedules wfs,
3033: wip_accounting_classes wac
3034: where mmt.transaction_id = i_txn_id
3035: and mmt.organization_id = i_org_id
3036: and wfs.organization_id = i_org_id