eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_PRJMFG_COST_COLLECTOR dependencies on MTL_MATERIAL_TRANSACTIONS

Line 344: UPDATE mtl_material_transactions mmt

340: -- is PJM enabled
341: ------------------------------------------------------------------
342: l_stmt_num := 20;
343:
344: UPDATE mtl_material_transactions mmt
345: SET mmt.pm_cost_collected = NULL,
346: mmt.last_update_date = sysdate,
347: mmt.last_updated_by = p_user_id,
348: mmt.last_update_login = p_login_id,

Line 367: UPDATE mtl_material_transactions mmt

363: ELSE
364:
365: l_stmt_num := 25;
366:
367: UPDATE mtl_material_transactions mmt
368: SET mmt.pm_cost_collected = NULL,
369: mmt.last_update_date = sysdate,
370: mmt.last_updated_by = p_user_id,
371: mmt.last_update_login = p_login_id,

Line 397: mtl_material_transactions mmt

393:
394: l_stmt_num := 30;
395:
396: UPDATE
397: mtl_material_transactions mmt
398: SET mmt.pm_cost_collected = NULL,
399: mmt.last_update_date = sysdate,
400: mmt.last_updated_by = p_user_id,
401: mmt.last_update_login = p_login_id,

Line 428: mtl_material_transactions mmt

424: /* cost collected. Retroactive price updates will laso be set as cost */
425: /* collected */
426:
427: UPDATE
428: mtl_material_transactions mmt
429: SET mmt.pm_cost_collected = NULL,
430: mmt.last_update_date = sysdate,
431: mmt.last_updated_by = p_user_id,
432: mmt.last_update_login = p_login_id,

Line 596: FROM mtl_material_transactions mmt

592: c_prior_days NUMBER,
593: c_proj_misc_txn_only NUMBER,
594: c_user_spec_group_size NUMBER) IS
595: SELECT NULL
596: FROM mtl_material_transactions mmt
597: WHERE mmt.transaction_id in (
598: SELECT cpmtv.transaction_id
599: FROM cst_pm_matl_txn_v cpmtv
600: WHERE cpmtv.organization_id = c_Org_Id

Line 631: SELECT mtl_material_transactions_s.nextval

627:
628:
629: l_stmt_num := 10;
630:
631: SELECT mtl_material_transactions_s.nextval
632: INTO p_group_id
633: FROM dual;
634:
635: l_stmt_num := 20;

Line 643: UPDATE mtl_material_transactions mmt

639: p_proj_misc_txn_only,
640: p_user_spec_group_size) LOOP
641:
642:
643: UPDATE mtl_material_transactions mmt
644: SET mmt.pm_cost_collector_group_id = p_group_id,
645: mmt.last_update_date = sysdate,
646: mmt.last_updated_by = p_user_id,
647: mmt.last_update_login = p_login_id,

Line 817: UPDATE mtl_material_transactions mmt

813: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Transfer between same project and task.' ||
814: ' No need to collect cost');
815: end if;
816:
817: UPDATE mtl_material_transactions mmt
818: SET mmt.pm_cost_collected = NULL,
819: mmt.pm_cost_collector_group_id = NULL,
820: mmt.last_update_date = sysdate,
821: mmt.last_updated_by = p_user_id,

Line 936: UPDATE mtl_material_transactions mmt

932: the transfer to projects field does not show "Not Applicable" */
933:
934: If cpmtv_rec.transaction_action_id <> 12 then
935:
936: UPDATE mtl_material_transactions mmt
937: SET mmt.pm_cost_collected = NULL,
938: mmt.pm_cost_collector_group_id = cpmtv_rec.pm_cost_collector_group_id,
939: mmt.last_update_date = sysdate,
940: mmt.last_updated_by = p_user_id,

Line 950: UPDATE mtl_material_transactions mmt

946: WHERE mmt.transaction_id IN (p_transaction_id, cpmtv_rec.transfer_transaction_id);
947:
948: else
949:
950: UPDATE mtl_material_transactions mmt
951: SET mmt.pm_cost_collected = NULL,
952: mmt.pm_cost_collector_group_id = cpmtv_rec.pm_cost_collector_group_id,
953: mmt.last_update_date = sysdate,
954: mmt.last_updated_by = p_user_id,

Line 987: UPDATE mtl_material_transactions mmt

983: l_err_num := 0;
984:
985: BEGIN
986:
987: UPDATE mtl_material_transactions mmt
988: SET
989: mmt.error_explanation = l_err_msg,
990: mmt.pm_cost_collector_group_id = null,
991: mmt.last_update_date = sysdate,

Line 1079: UPDATE mtl_material_transactions mmt

1075: END IF;
1076:
1077: ELSE
1078:
1079: UPDATE mtl_material_transactions mmt
1080: SET mmt.pm_cost_collected = NULL,
1081: mmt.pm_cost_collector_group_id = NULL,
1082: mmt.last_update_date = sysdate,
1083: mmt.last_updated_by = p_user_id,

Line 1994: mtl_material_transactions mmt

1990: 'P' transaction_status_code,
1991: mcacd.cost_element_id cost_element_id,
1992: p_denom_currency_code denom_currency_code
1993: FROM mtl_cst_actual_cost_details mcacd,
1994: mtl_material_transactions mmt
1995: WHERE mmt.transaction_id = p_transaction_id
1996: AND mmt.transaction_id = mcacd.transaction_id
1997: AND mcacd.organization_id = p_organization_id
1998: AND mcacd.inventory_item_id = p_inventory_item_id

Line 2566: FROM mtl_material_transactions mmt,

2562: p_inv_syslink_literal system_linkage,
2563: 'P' transaction_status_code ,
2564: NULL cost_element_id,
2565: p_denom_currency_code denom_currency_code
2566: FROM mtl_material_transactions mmt,
2567: pjm_project_parameters ppp,
2568: pjm_org_parameters pop
2569: WHERE mmt.transaction_id = decode(ppv_txfr_flag,1, p_transfer_transaction_id,
2570: p_transaction_id)

Line 2690: mtl_material_transactions mmt

2686:
2687: SELECT max(pop.common_project_id)
2688: INTO l_default_project
2689: FROM pjm_org_parameters pop,
2690: mtl_material_transactions mmt
2691: WHERE pop.organization_id = mmt.organization_id
2692: AND mmt.transaction_id = p_transaction_id;
2693:
2694: ----------------------------------------------------------------------

Line 2841: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT

2837: -- Modified for fob stamping project
2838: IF (p_transfer_organization_id IS NOT NULL) THEN
2839: IF p_transaction_action_id = 21 THEN /* Intransit Shipment */
2840: SELECT nvl(MMT.fob_point, MSNV.fob_point) INTO l_fob_point
2841: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT
2842: WHERE MSNV.from_organization_id = p_organization_id
2843: AND MSNV.to_organization_id = p_transfer_organization_id
2844: AND MMT.transaction_id = p_transaction_id;
2845: ELSIF p_transaction_action_id = 12 THEN /* Intransit Receipt */

Line 2847: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT

2843: AND MSNV.to_organization_id = p_transfer_organization_id
2844: AND MMT.transaction_id = p_transaction_id;
2845: ELSIF p_transaction_action_id = 12 THEN /* Intransit Receipt */
2846: SELECT nvl(MMT.fob_point, MSNV.fob_point) INTO l_fob_point
2847: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT
2848: WHERE MSNV.from_organization_id = p_transfer_organization_id
2849: AND MSNV.to_organization_id = p_organization_id
2850: AND MMT.transaction_id = p_transaction_id;
2851: END IF;

Line 2934: FROM mtl_material_transactions

2930:
2931: l_stmt_num := 110;
2932: SELECT transaction_type_id
2933: INTO l_txn_type
2934: FROM mtl_material_transactions
2935: WHERE transaction_id = p_transaction_id;
2936:
2937: l_stmt_num := 120;
2938:

Line 3307: from mtl_material_transactions

3303: /* changes to support the Blue print organizations */
3304:
3305: /* get the org ID on the transfer Txn */
3306: select organization_id into l_org_id
3307: from mtl_material_transactions
3308: where transaction_id = c_rec9.orig_transaction_reference;
3309:
3310: /* set the transaction source accordingly if the org is BP */
3311:

Line 3644: MTL_MATERIAL_TRANSACTIONS

3640: EXPENDITURE_TYPE
3641: INTO
3642: l_exp_type
3643: FROM
3644: MTL_MATERIAL_TRANSACTIONS
3645: WHERE
3646: transaction_id = p_transaction_id;
3647: ELSE
3648: SELECT

Line 3851: FROM MTL_MATERIAL_TRANSACTIONS

3847: IF( ( p_transaction_action_id = 1 AND p_transaction_source_type_id = 8 )
3848: OR p_transaction_action_id = 17 ) THEN
3849: SELECT EXPENDITURE_TYPE
3850: INTO c_rec4.EXPENDITURE_TYPE
3851: FROM MTL_MATERIAL_TRANSACTIONS
3852: WHERE transaction_id = p_transaction_id;
3853: END IF;
3854:
3855: l_stmt_num := 180;

Line 3861: from mtl_material_transactions

3857: /* changes to support the Blue print organizations */
3858:
3859: /* get the org ID on the transfer Txn */
3860: select organization_id into l_org_id
3861: from mtl_material_transactions
3862: where transaction_id = c_rec4.orig_transaction_reference;
3863:
3864: /* set the transaction source accordingly if the org is BP */
3865:

Line 4040: FROM mtl_material_transactions mmt

4036: warning but do not reset the pm_cost_collected flag to error.
4037: */
4038: SELECT mmt.costed_flag
4039: INTO l_costed_flag
4040: FROM mtl_material_transactions mmt
4041: WHERE mmt.transaction_id = decode(p_transaction_action_id,
4042: 3, p_transfer_transaction_id ,
4043: p_transaction_id)
4044: AND mmt.organization_id = decode(p_transaction_action_id,

Line 4582: from mtl_material_transactions

4578:
4579: If p_transaction_action_id = 3 then
4580:
4581: select organization_id into l_org_id
4582: from mtl_material_transactions
4583: where transaction_id = c_rec7.orig_transaction_reference;
4584:
4585: /* set the transaction source accordingly if the org is BP */
4586:

Line 5438: UPDATE mtl_material_transactions mmt

5434:
5435: /* update the errorcode and error_explanation fields inspite of the
5436: maintenance of the log file */
5437:
5438: UPDATE mtl_material_transactions mmt
5439: SET mmt.pm_cost_collected = 'E',
5440: mmt.error_code = p_error_code,
5441: mmt.error_explanation = p_error_explanation,
5442: mmt.last_update_date = sysdate,

Line 6504: FROM mtl_material_transactions mmt,

6500: l_inventory_item_id,
6501: l_mmt_primary_quantity,
6502: l_txn_type_id,
6503: l_type_class
6504: FROM mtl_material_transactions mmt,
6505: mtl_transaction_types mtt
6506: WHERE mmt.transaction_id = p_transaction_id
6507: AND mtt.transaction_type_id = mmt.transaction_type_id;
6508:

Line 6516: FROM MTL_MATERIAL_TRANSACTIONS mmt,

6512: msi.asset_inventory
6513: INTO
6514: l_subinventory_code,
6515: l_si_asset_yes_no
6516: FROM MTL_MATERIAL_TRANSACTIONS mmt,
6517: MTL_SECONDARY_INVENTORIES msi
6518: WHERE
6519: mmt.transaction_id = p_transaction_id
6520: AND msi.secondary_inventory_name = mmt.subinventory_code

Line 6569: mtl_material_transactions MMT

6565: IF (l_xfer_organization_id IS NOT NULL) THEN
6566: IF l_transaction_action_id = 21 THEN /* Intransit Shipment */
6567: SELECT nvl(MMT.fob_point, MSNV.fob_point) INTO l_fob_point
6568: FROM mtl_shipping_network_view MSNV,
6569: mtl_material_transactions MMT
6570: WHERE MSNV.from_organization_id = l_organization_id
6571: AND MSNV.to_organization_id = l_xfer_organization_id
6572: AND MMT.transaction_id = p_transaction_id;
6573: ELSIF l_transaction_action_id = 12 THEN /* Intransit Receipt */

Line 6577: mtl_material_transactions MMT

6573: ELSIF l_transaction_action_id = 12 THEN /* Intransit Receipt */
6574: SELECT nvl(MMT.fob_point, MSNV.fob_point)
6575: INTO l_fob_point
6576: FROM mtl_shipping_network_view MSNV,
6577: mtl_material_transactions MMT
6578: WHERE MSNV.from_organization_id = l_xfer_organization_id
6579: AND MSNV.to_organization_id = l_organization_id
6580: AND MMT.transaction_id = p_transaction_id;
6581: END IF;

Line 7358: mtl_material_transactions mmt

7354:
7355: select to_number(org_information3)
7356: into l_op_unit
7357: from hr_organization_information hoi,
7358: mtl_material_transactions mmt
7359: where hoi.organization_id = mmt.organization_id
7360: and mmt.transaction_id = to_number(p_orig_transaction_reference)
7361: and org_information_context ='Accounting Information';
7362: