DBA Data[Home] [Help]

APPS.CSTPACDP dependencies on WIP_FLOW_SCHEDULES

Line 926: from wip_flow_schedules wdj,

922: l_stmt_num := 22;
923:
924: select decode(class_type,1,0,3,0,1), -1
925: into l_exp_sub2, l_exp_acct2
926: from wip_flow_schedules wdj,
927: wip_accounting_classes wac
928: where
929: wdj.wip_entity_id = I_TXN_SRC_ID and
930: wdj.class_code = wac.class_code and

Line 1032: from wip_flow_schedules

1028: select material_account, material_overhead_account, resource_account,
1029: outside_processing_account, overhead_account, class_code
1030: into l_mat_acct, l_mat_ovhd_acct, l_res_acct, l_osp_acct, l_ovhd_acct,
1031: l_acct_class
1032: from wip_flow_schedules
1033: where organization_id = i_org_id
1034: and wip_entity_id = i_txn_src_id;
1035:
1036: END IF;

Line 1211: FROM wip_flow_schedules

1207: INTO l_mat_acct, l_mat_ovhd_acct, l_res_acct,
1208: l_osp_acct, l_ovhd_acct, l_acct_class,
1209: l_mat_var_acct, l_res_var_acct,
1210: l_osp_var_acct, l_ovhd_var_acct
1211: FROM wip_flow_schedules
1212: WHERE organization_id = i_org_id
1213: AND wip_entity_id = i_txn_src_id;
1214:
1215: ELSE

Line 1220: FROM wip_flow_schedules

1216: SELECT material_account, material_overhead_account, resource_account,
1217: outside_processing_account, overhead_account, class_code
1218: INTO l_mat_acct, l_mat_ovhd_acct, l_res_acct, l_osp_acct, l_ovhd_acct,
1219: l_acct_class
1220: FROM wip_flow_schedules
1221: WHERE organization_id = i_org_id
1222: AND wip_entity_id = i_txn_src_id;
1223: END IF;
1224: