DBA Data[Home] [Help]

APPS.CSTPAVCP dependencies on WIP_FLOW_SCHEDULES

Line 1475: -- cfm then use wip_flow_schedules

1471: fnd_file.put_line(fnd_file.log,'Common Issue to WIP');
1472: end if;
1473:
1474: if(i_flow_schedule = 1) then
1475: -- cfm then use wip_flow_schedules
1476: -- class_type 1 and 3 : asset job, 4 : exp job
1477: l_stmt_num := 44;
1478: if (g_debug = 'Y') then
1479: fnd_file.put_line(fnd_file.log,'Flow Schedule');

Line 1488: wip_flow_schedules wfs,

1484: 6, 0,
1485: 4, decode(l_exp1, 1, 1, 0))
1486: into l_exp2
1487: from mtl_material_transactions mmt,
1488: wip_flow_schedules wfs,
1489: wip_accounting_classes wac
1490: where mmt.transaction_id = i_txn_id
1491: and mmt.organization_id = i_org_id
1492: and wfs.organization_id = i_org_id

Line 2400: wip_flow_schedules wfs,

2396: 6, 0,
2397: 4, decode(i_exp_flag, 1, 1, 0))
2398: into l_exp_flag
2399: from mtl_material_transactions mmt,
2400: wip_flow_schedules wfs,
2401: wip_accounting_classes wac
2402: where mmt.transaction_id = i_txn_id
2403: and mmt.organization_id = i_org_id
2404: and wfs.organization_id = i_org_id