APPS.CST_PRJMFG_COST_COLLECTOR dependencies on WIP_TRANSACTIONS

Line 472: /* Check WIP Transactions Table for Prj/Tsk Ref Rather than the Job Header */

468:
469: l_stmt_num := 40;
470:
471: /* Bug # 589460 PJM AUTO TASK API */
472: /* Check WIP Transactions Table for Prj/Tsk Ref Rather than the Job Header */
473: UPDATE
474: wip_transactions wt
475: SET wt.pm_cost_collected = NULL,
476: wt.last_update_date = sysdate,

Line 474: wip_transactions wt

470:
471: /* Bug # 589460 PJM AUTO TASK API */
472: /* Check WIP Transactions Table for Prj/Tsk Ref Rather than the Job Header */
473: UPDATE
474: wip_transactions wt
475: SET wt.pm_cost_collected = NULL,
476: wt.last_update_date = sysdate,
477: wt.last_updated_by = p_user_id,
478: wt.last_update_login = p_login_id,

Line 1208: FROM wip_transactions wt

1204: CURSOR sel_wt_trx ( c_Org_Id NUMBER,
1205: c_prior_days NUMBER,
1206: c_user_spec_group_size NUMBER) IS
1207: SELECT NULL
1208: FROM wip_transactions wt
1209: WHERE wt.organization_id = c_Org_Id
1210: AND wt.transaction_date <= ((trunc(sysdate) - c_prior_days) + 0.99999)
1211: AND wt.pm_cost_collected = 'N'
1212: AND wt.transaction_type in (1,2,3,17)

Line 1243: SELECT wip_transactions_S.nextval

1239: end if;
1240:
1241: l_stmt_num := 10;
1242:
1243: SELECT wip_transactions_S.nextval
1244: INTO l_group_id
1245: FROM dual;
1246:
1247: p_group_id := l_group_id;

Line 1254: UPDATE wip_transactions wt

1250: FOR sel_wt_rec IN sel_wt_trx( p_Org_Id,
1251: p_prior_days,
1252: p_user_spec_group_size) LOOP
1253:
1254: UPDATE wip_transactions wt
1255: SET wt.pm_cost_collector_group_id = l_group_id,
1256: wt.last_update_date = sysdate,
1257: wt.last_updated_by = p_user_id,
1258: wt.last_update_login = p_login_id,

Line 1275: FROM wip_transactions wt

1271:
1272: DELETE wip_txn_interface_errors wite
1273: WHERE wite.transaction_id in
1274: ( SELECT wt.transaction_id
1275: FROM wip_transactions wt
1276: WHERE wt.pm_cost_collector_group_id = l_group_id
1277: AND wt.pm_cost_collected = 'N' )
1278: AND wite.error_column = 'PM_COST_COLLECTED';
1279:

Line 1381: wip_transactions wt,

1377: wta.basis_resource_id c_basis_resource_id,
1378: wta.reference_account c_reference_account,
1379: wta.wip_sub_ledger_id c_wip_dr_sub_ledger_id
1380: FROM wip_transaction_accounts wta,
1381: wip_transactions wt,
1382: bom_resources br,
1383: bom_departments bd,
1384: per_people_f ppf
1385: WHERE wt.transaction_type in (1,2,3)

Line 1427: wip_transactions wt,

1423: wta.basis_resource_id c_basis_resource_id,
1424: wta.reference_account c_reference_account,
1425: wta.wip_sub_ledger_id c_wip_dr_sub_ledger_id
1426: FROM wip_transaction_accounts wta,
1427: wip_transactions wt,
1428: pjm_project_parameters ppp,
1429: po_lines_all pla
1430: WHERE wt.transaction_type = 17
1431: AND pla.po_line_id = wt.po_line_id

Line 1646: UPDATE wip_transactions wt

1642: ELSE
1643:
1644: l_stmt_num := 20;
1645:
1646: UPDATE wip_transactions wt
1647: SET wt.pm_cost_collected = NULL,
1648: wt.last_update_date = sysdate,
1649: wt.last_updated_by = p_user_id,
1650: wt.last_update_login = p_login_id,

Line 5843: from wip_transactions

5839:
5840: /* get the primary UOM code directly from the transaction */
5841:
5842: select primary_uom into l_uom_code
5843: from wip_transactions
5844: where transaction_id = p_transaction_id ;
5845:
5846: If l_debug = 'Y' then
5847: fnd_file.put_line(fnd_file.log,' UOM code for the WIP txn : ' || l_uom_code);

Line 6322: UPDATE wip_transactions wt

6318:
6319:
6320: l_stmt_num := 10;
6321:
6322: UPDATE wip_transactions wt
6323: SET wt.pm_cost_collected = 'E',
6324: wt.last_update_date = sysdate,
6325: wt.last_updated_by = p_user_id,
6326: wt.last_update_login = p_login_id,