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 345: UPDATE mtl_material_transactions mmt

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

Line 368: UPDATE mtl_material_transactions mmt

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

Line 398: mtl_material_transactions mmt

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

Line 429: mtl_material_transactions mmt

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

Line 518: UPDATE mtl_material_transactions mmt

514: check in MTA, if no MOH was absorbed or not in MTA (in this case MTA doesn't even exists), if none is found mark it as not applicable*/
515:
516: l_stmt_num := 41;
517:
518: UPDATE mtl_material_transactions mmt
519: SET mmt.pm_cost_collected = NULL,
520: mmt.last_update_date = sysdate,
521: mmt.last_updated_by = p_user_id,
522: mmt.last_update_login = p_login_id,

Line 630: FROM mtl_material_transactions mmt

626: c_prior_days NUMBER,
627: c_proj_misc_txn_only NUMBER,
628: c_user_spec_group_size NUMBER) IS
629: SELECT NULL
630: FROM mtl_material_transactions mmt
631: WHERE mmt.transaction_id in (
632: SELECT cpmtv.transaction_id
633: FROM cst_pm_matl_txn_v cpmtv
634: WHERE cpmtv.organization_id = c_Org_Id

Line 665: SELECT mtl_material_transactions_s.nextval

661:
662:
663: l_stmt_num := 10;
664:
665: SELECT mtl_material_transactions_s.nextval
666: INTO p_group_id
667: FROM dual;
668:
669: l_stmt_num := 20;

Line 677: UPDATE mtl_material_transactions mmt

673: p_proj_misc_txn_only,
674: p_user_spec_group_size) LOOP
675:
676:
677: UPDATE mtl_material_transactions mmt
678: SET mmt.pm_cost_collector_group_id = p_group_id,
679: mmt.last_update_date = sysdate,
680: mmt.last_updated_by = p_user_id,
681: mmt.last_update_login = p_login_id,

Line 851: UPDATE mtl_material_transactions mmt

847: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Transfer between same project and task.' ||
848: ' No need to collect cost');
849: end if;
850:
851: UPDATE mtl_material_transactions mmt
852: SET mmt.pm_cost_collected = NULL,
853: mmt.pm_cost_collector_group_id = NULL,
854: mmt.last_update_date = sysdate,
855: mmt.last_updated_by = p_user_id,

Line 970: UPDATE mtl_material_transactions mmt

966: the transfer to projects field does not show "Not Applicable" */
967:
968: If cpmtv_rec.transaction_action_id <> 12 then
969:
970: UPDATE mtl_material_transactions mmt
971: SET mmt.pm_cost_collected = NULL,
972: mmt.pm_cost_collector_group_id = cpmtv_rec.pm_cost_collector_group_id,
973: mmt.last_update_date = sysdate,
974: mmt.last_updated_by = p_user_id,

Line 984: UPDATE mtl_material_transactions mmt

980: WHERE mmt.transaction_id IN (p_transaction_id, cpmtv_rec.transfer_transaction_id);
981:
982: else
983:
984: UPDATE mtl_material_transactions mmt
985: SET mmt.pm_cost_collected = NULL,
986: mmt.pm_cost_collector_group_id = cpmtv_rec.pm_cost_collector_group_id,
987: mmt.last_update_date = sysdate,
988: mmt.last_updated_by = p_user_id,

Line 1021: UPDATE mtl_material_transactions mmt

1017: l_err_num := 0;
1018:
1019: BEGIN
1020:
1021: UPDATE mtl_material_transactions mmt
1022: SET
1023: mmt.error_explanation = l_err_msg,
1024: mmt.pm_cost_collector_group_id = null,
1025: mmt.last_update_date = sysdate,

Line 1113: UPDATE mtl_material_transactions mmt

1109: END IF;
1110:
1111: ELSE
1112:
1113: UPDATE mtl_material_transactions mmt
1114: SET mmt.pm_cost_collected = NULL,
1115: mmt.pm_cost_collector_group_id = NULL,
1116: mmt.last_update_date = sysdate,
1117: mmt.last_updated_by = p_user_id,

Line 2055: mtl_material_transactions mmt

2051: 'P' transaction_status_code,
2052: mcacd.cost_element_id cost_element_id,
2053: p_denom_currency_code denom_currency_code
2054: FROM mtl_cst_actual_cost_details mcacd,
2055: mtl_material_transactions mmt
2056: WHERE mmt.transaction_id = p_transaction_id
2057: AND mmt.transaction_id = mcacd.transaction_id
2058: AND mcacd.organization_id = p_organization_id
2059: AND mcacd.inventory_item_id = p_inventory_item_id

Line 2627: FROM mtl_material_transactions mmt,

2623: p_inv_syslink_literal system_linkage,
2624: 'P' transaction_status_code ,
2625: NULL cost_element_id,
2626: p_denom_currency_code denom_currency_code
2627: FROM mtl_material_transactions mmt,
2628: pjm_project_parameters ppp,
2629: pjm_org_parameters pop
2630: WHERE mmt.transaction_id = decode(ppv_txfr_flag,1, p_transfer_transaction_id,
2631: p_transaction_id)

Line 2751: mtl_material_transactions mmt

2747:
2748: SELECT max(pop.common_project_id)
2749: INTO l_default_project
2750: FROM pjm_org_parameters pop,
2751: mtl_material_transactions mmt
2752: WHERE pop.organization_id = mmt.organization_id
2753: AND mmt.transaction_id = p_transaction_id;
2754:
2755: ----------------------------------------------------------------------

Line 2902: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT

2898: -- Modified for fob stamping project
2899: IF (p_transfer_organization_id IS NOT NULL) THEN
2900: IF p_transaction_action_id = 21 THEN /* Intransit Shipment */
2901: SELECT nvl(MMT.fob_point, MSNV.fob_point) INTO l_fob_point
2902: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT
2903: WHERE MSNV.from_organization_id = p_organization_id
2904: AND MSNV.to_organization_id = p_transfer_organization_id
2905: AND MMT.transaction_id = p_transaction_id;
2906: ELSIF p_transaction_action_id = 12 THEN /* Intransit Receipt */

Line 2908: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT

2904: AND MSNV.to_organization_id = p_transfer_organization_id
2905: AND MMT.transaction_id = p_transaction_id;
2906: ELSIF p_transaction_action_id = 12 THEN /* Intransit Receipt */
2907: SELECT nvl(MMT.fob_point, MSNV.fob_point) INTO l_fob_point
2908: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT
2909: WHERE MSNV.from_organization_id = p_transfer_organization_id
2910: AND MSNV.to_organization_id = p_organization_id
2911: AND MMT.transaction_id = p_transaction_id;
2912: END IF;

Line 2995: FROM mtl_material_transactions

2991:
2992: l_stmt_num := 110;
2993: SELECT transaction_type_id
2994: INTO l_txn_type
2995: FROM mtl_material_transactions
2996: WHERE transaction_id = p_transaction_id;
2997:
2998: l_stmt_num := 120;
2999:

Line 3368: from mtl_material_transactions

3364: /* changes to support the Blue print organizations */
3365:
3366: /* get the org ID on the transfer Txn */
3367: select organization_id into l_org_id
3368: from mtl_material_transactions
3369: where transaction_id = c_rec9.orig_transaction_reference;
3370:
3371: /* set the transaction source accordingly if the org is BP */
3372:

Line 3705: MTL_MATERIAL_TRANSACTIONS

3701: EXPENDITURE_TYPE
3702: INTO
3703: l_exp_type
3704: FROM
3705: MTL_MATERIAL_TRANSACTIONS
3706: WHERE
3707: transaction_id = p_transaction_id;
3708: ELSE
3709: SELECT

Line 3912: FROM MTL_MATERIAL_TRANSACTIONS

3908: IF( ( p_transaction_action_id = 1 AND p_transaction_source_type_id = 8 )
3909: OR p_transaction_action_id = 17 ) THEN
3910: SELECT EXPENDITURE_TYPE
3911: INTO c_rec4.EXPENDITURE_TYPE
3912: FROM MTL_MATERIAL_TRANSACTIONS
3913: WHERE transaction_id = p_transaction_id;
3914: END IF;
3915:
3916: l_stmt_num := 180;

Line 3922: from mtl_material_transactions

3918: /* changes to support the Blue print organizations */
3919:
3920: /* get the org ID on the transfer Txn */
3921: select organization_id into l_org_id
3922: from mtl_material_transactions
3923: where transaction_id = c_rec4.orig_transaction_reference;
3924:
3925: /* set the transaction source accordingly if the org is BP */
3926:

Line 4101: FROM mtl_material_transactions mmt

4097: warning but do not reset the pm_cost_collected flag to error.
4098: */
4099: SELECT mmt.costed_flag
4100: INTO l_costed_flag
4101: FROM mtl_material_transactions mmt
4102: WHERE mmt.transaction_id = decode(p_transaction_action_id,
4103: 3, p_transfer_transaction_id ,
4104: p_transaction_id)
4105: AND mmt.organization_id = decode(p_transaction_action_id,

Line 4643: from mtl_material_transactions

4639:
4640: If p_transaction_action_id = 3 then
4641:
4642: select organization_id into l_org_id
4643: from mtl_material_transactions
4644: where transaction_id = c_rec7.orig_transaction_reference;
4645:
4646: /* set the transaction source accordingly if the org is BP */
4647:

Line 5499: UPDATE mtl_material_transactions mmt

5495:
5496: /* update the errorcode and error_explanation fields inspite of the
5497: maintenance of the log file */
5498:
5499: UPDATE mtl_material_transactions mmt
5500: SET mmt.pm_cost_collected = 'E',
5501: mmt.error_code = p_error_code,
5502: mmt.error_explanation = p_error_explanation,
5503: mmt.last_update_date = sysdate,

Line 6641: FROM mtl_material_transactions mmt,

6637: l_inventory_item_id,
6638: l_mmt_primary_quantity,
6639: l_txn_type_id,
6640: l_type_class
6641: FROM mtl_material_transactions mmt,
6642: mtl_transaction_types mtt
6643: WHERE mmt.transaction_id = p_transaction_id
6644: AND mtt.transaction_type_id = mmt.transaction_type_id;
6645:

Line 6653: FROM MTL_MATERIAL_TRANSACTIONS mmt,

6649: msi.asset_inventory
6650: INTO
6651: l_subinventory_code,
6652: l_si_asset_yes_no
6653: FROM MTL_MATERIAL_TRANSACTIONS mmt,
6654: MTL_SECONDARY_INVENTORIES msi
6655: WHERE
6656: mmt.transaction_id = p_transaction_id
6657: AND msi.secondary_inventory_name = mmt.subinventory_code

Line 6706: mtl_material_transactions MMT

6702: IF (l_xfer_organization_id IS NOT NULL) THEN
6703: IF l_transaction_action_id = 21 THEN /* Intransit Shipment */
6704: SELECT nvl(MMT.fob_point, MSNV.fob_point) INTO l_fob_point
6705: FROM mtl_shipping_network_view MSNV,
6706: mtl_material_transactions MMT
6707: WHERE MSNV.from_organization_id = l_organization_id
6708: AND MSNV.to_organization_id = l_xfer_organization_id
6709: AND MMT.transaction_id = p_transaction_id;
6710: ELSIF l_transaction_action_id = 12 THEN /* Intransit Receipt */

Line 6714: mtl_material_transactions MMT

6710: ELSIF l_transaction_action_id = 12 THEN /* Intransit Receipt */
6711: SELECT nvl(MMT.fob_point, MSNV.fob_point)
6712: INTO l_fob_point
6713: FROM mtl_shipping_network_view MSNV,
6714: mtl_material_transactions MMT
6715: WHERE MSNV.from_organization_id = l_xfer_organization_id
6716: AND MSNV.to_organization_id = l_organization_id
6717: AND MMT.transaction_id = p_transaction_id;
6718: END IF;

Line 7595: mtl_material_transactions mmt

7591:
7592: select to_number(org_information3)
7593: into l_op_unit
7594: from hr_organization_information hoi,
7595: mtl_material_transactions mmt
7596: where hoi.organization_id = mmt.organization_id
7597: and mmt.transaction_id = to_number(p_orig_transaction_reference)
7598: and org_information_context ='Accounting Information';
7599: