DBA Data[Home] [Help]

APPS.CSTPACDP dependencies on WIP_FLOW_SCHEDULES

Line 1017: from wip_flow_schedules wdj,

1013: l_stmt_num := 22;
1014:
1015: select decode(class_type,1,0,3,0,1), -1
1016: into l_exp_sub2, l_exp_acct2
1017: from wip_flow_schedules wdj,
1018: wip_accounting_classes wac
1019: where
1020: wdj.wip_entity_id = I_TXN_SRC_ID and
1021: wdj.class_code = wac.class_code and

Line 1123: from wip_flow_schedules

1119: select material_account, material_overhead_account, resource_account,
1120: outside_processing_account, overhead_account, class_code
1121: into l_mat_acct, l_mat_ovhd_acct, l_res_acct, l_osp_acct, l_ovhd_acct,
1122: l_acct_class
1123: from wip_flow_schedules
1124: where organization_id = i_org_id
1125: and wip_entity_id = i_txn_src_id;
1126:
1127: END IF;

Line 1302: FROM wip_flow_schedules

1298: INTO l_mat_acct, l_mat_ovhd_acct, l_res_acct,
1299: l_osp_acct, l_ovhd_acct, l_acct_class,
1300: l_mat_var_acct, l_res_var_acct,
1301: l_osp_var_acct, l_ovhd_var_acct
1302: FROM wip_flow_schedules
1303: WHERE organization_id = i_org_id
1304: AND wip_entity_id = i_txn_src_id;
1305:
1306: ELSE

Line 1311: FROM wip_flow_schedules

1307: SELECT material_account, material_overhead_account, resource_account,
1308: outside_processing_account, overhead_account, class_code
1309: INTO l_mat_acct, l_mat_ovhd_acct, l_res_acct, l_osp_acct, l_ovhd_acct,
1310: l_acct_class
1311: FROM wip_flow_schedules
1312: WHERE organization_id = i_org_id
1313: AND wip_entity_id = i_txn_src_id;
1314: END IF;
1315: