APPS.CST_PRJMFG_COST_COLLECTOR dependencies on WIP_TRANSACTIONS

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

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

Line 476: wip_transactions wt

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

Line 1242: FROM wip_transactions wt

1238: CURSOR sel_wt_trx ( c_Org_Id NUMBER,
1239: c_prior_days NUMBER,
1240: c_user_spec_group_size NUMBER) IS
1241: SELECT NULL
1242: FROM wip_transactions wt
1243: WHERE wt.organization_id = c_Org_Id
1244: AND wt.transaction_date <= ((trunc(sysdate) - c_prior_days) + 0.99999)
1245: AND wt.pm_cost_collected = 'N'
1246: AND wt.transaction_type in (1,2,3,17)

Line 1277: SELECT wip_transactions_S.nextval

1273: end if;
1274:
1275: l_stmt_num := 10;
1276:
1277: SELECT wip_transactions_S.nextval
1278: INTO l_group_id
1279: FROM dual;
1280:
1281: p_group_id := l_group_id;

Line 1288: UPDATE wip_transactions wt

1284: FOR sel_wt_rec IN sel_wt_trx( p_Org_Id,
1285: p_prior_days,
1286: p_user_spec_group_size) LOOP
1287:
1288: UPDATE wip_transactions wt
1289: SET wt.pm_cost_collector_group_id = l_group_id,
1290: wt.last_update_date = sysdate,
1291: wt.last_updated_by = p_user_id,
1292: wt.last_update_login = p_login_id,

Line 1309: FROM wip_transactions wt

1305:
1306: DELETE wip_txn_interface_errors wite
1307: WHERE wite.transaction_id in
1308: ( SELECT wt.transaction_id
1309: FROM wip_transactions wt
1310: WHERE wt.pm_cost_collector_group_id = l_group_id
1311: AND wt.pm_cost_collected = 'N' )
1312: AND wite.error_column = 'PM_COST_COLLECTED';
1313:

Line 1416: wip_transactions wt,

1412: wta.reference_account c_reference_account,
1413: wta.wip_sub_ledger_id c_wip_dr_sub_ledger_id,
1414: nvl2(ppf.npw_number,'CTW',null) c_person_type
1415: FROM wip_transaction_accounts wta,
1416: wip_transactions wt,
1417: bom_resources br,
1418: bom_departments bd,
1419: per_people_f ppf
1420: WHERE wt.transaction_type in (1,2,3)

Line 1469: wip_transactions wt,

1465: wta.reference_account c_reference_account,
1466: wta.wip_sub_ledger_id c_wip_dr_sub_ledger_id,
1467: NULL c_person_type
1468: FROM wip_transaction_accounts wta,
1469: wip_transactions wt,
1470: pjm_project_parameters ppp,
1471: po_lines_all pla
1472: WHERE wt.transaction_type = 17
1473: AND pla.po_line_id = wt.po_line_id

Line 1707: UPDATE wip_transactions wt

1703: ELSE
1704:
1705: l_stmt_num := 20;
1706:
1707: UPDATE wip_transactions wt
1708: SET wt.pm_cost_collected = NULL,
1709: wt.last_update_date = sysdate,
1710: wt.last_updated_by = p_user_id,
1711: wt.last_update_login = p_login_id,

Line 5910: from wip_transactions

5906:
5907: /* get the primary UOM code directly from the transaction */
5908:
5909: select primary_uom into l_uom_code
5910: from wip_transactions
5911: where transaction_id = p_transaction_id ;
5912:
5913: l_stmt_num := 62;
5914: If l_debug = 'Y' then

Line 6449: UPDATE wip_transactions wt

6445:
6446:
6447: l_stmt_num := 10;
6448:
6449: UPDATE wip_transactions wt
6450: SET wt.pm_cost_collected = 'E',
6451: wt.last_update_date = sysdate,
6452: wt.last_updated_by = p_user_id,
6453: wt.last_update_login = p_login_id,