DBA Data[Home] [Help]

APPS.CSTPAVCP dependencies on WIP_FLOW_SCHEDULES

Line 1323: -- cfm then use wip_flow_schedules

1319: fnd_file.put_line(fnd_file.log,'Common Issue to WIP');
1320: end if;
1321:
1322: if(i_flow_schedule = 1) then
1323: -- cfm then use wip_flow_schedules
1324: -- class_type 1 and 3 : asset job, 4 : exp job
1325: l_stmt_num := 44;
1326: if (g_debug = 'Y') then
1327: fnd_file.put_line(fnd_file.log,'Flow Schedule');

Line 1336: wip_flow_schedules wfs,

1332: 6, 0,
1333: 4, decode(l_exp1, 1, 1, 0))
1334: into l_exp2
1335: from mtl_material_transactions mmt,
1336: wip_flow_schedules wfs,
1337: wip_accounting_classes wac
1338: where mmt.transaction_id = i_txn_id
1339: and mmt.organization_id = i_org_id
1340: and wfs.organization_id = i_org_id

Line 2237: wip_flow_schedules wfs,

2233: 6, 0,
2234: 4, decode(i_exp_flag, 1, 1, 0))
2235: into l_exp_flag
2236: from mtl_material_transactions mmt,
2237: wip_flow_schedules wfs,
2238: wip_accounting_classes wac
2239: where mmt.transaction_id = i_txn_id
2240: and mmt.organization_id = i_org_id
2241: and wfs.organization_id = i_org_id