APPS.CST_PRJMFG_COST_COLLECTOR dependencies on CST_PM_MATL_TXN_V

Line 244: | 'cst_pm_matl_txn_v' and satisfy the date and org criteria are marked as |

240: | This procedure would mark all non-project world transactions as Cost |
241: | Collected for the Given Organization and Upto the Given Date. |
242: | |
243: | For MMT trasactions, all transactions that are not selected by the view |
244: | 'cst_pm_matl_txn_v' and satisfy the date and org criteria are marked as |
245: | cost collected with no exception. |
246: | |
247: | For WIP trasactions, transactions falling into either of these category |
248: | are marked as cost collected. |

Line 379: FROM cst_pm_matl_txn_v cpmtv

375: mmt.program_id = p_prg_id,
376: mmt.program_update_date = sysdate
377: WHERE NOT EXISTS
378: ( SELECT NULL
379: FROM cst_pm_matl_txn_v cpmtv
380: WHERE cpmtv.transaction_id = mmt.transaction_id )
381: AND mmt.organization_id = p_Org_Id
382: AND mmt.transaction_date <= ((trunc(sysdate) - p_prior_days) + 0.99999)
383: AND mmt.costed_flag is NULL

Line 633: FROM cst_pm_matl_txn_v cpmtv

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
635: AND cpmtv.transaction_date <=
636: ((trunc(sysdate) - c_prior_days) + 0.99999)
637: AND cpmtv.pm_cost_collector_group_id is NULL

Line 795: FROM cst_pm_matl_txn_v cpmtv

791: cpmtv.transfer_organization_id,
792: cpmtv.flow_schedule,
793: cpmtv.si_asset_yes_no,
794: cpmtv.transfer_si_asset_yes_no
795: FROM cst_pm_matl_txn_v cpmtv
796: WHERE cpmtv.transaction_id = c_Transaction_Id
797: AND cpmtv.organization_id = c_Organization_Id;
798:
799: l_proj_job_ind NUMBER;

Line 841: FROM cst_pm_matl_txn_v

837: to the source_task_id. In this case, set the cost_collected flag to
838: NULL and return. */
839: SELECT count(*)
840: INTO l_count
841: FROM cst_pm_matl_txn_v
842: WHERE transaction_id = p_transaction_id;
843:
844: IF (l_count = 0)
845: THEN