APPS.CST_PRJMFG_COST_COLLECTOR dependencies on CST_PM_MATL_TXN_V

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

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

Line 378: FROM cst_pm_matl_txn_v cpmtv

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

Line 599: FROM cst_pm_matl_txn_v cpmtv

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

Line 761: FROM cst_pm_matl_txn_v cpmtv

757: cpmtv.transfer_organization_id,
758: cpmtv.flow_schedule,
759: cpmtv.si_asset_yes_no,
760: cpmtv.transfer_si_asset_yes_no
761: FROM cst_pm_matl_txn_v cpmtv
762: WHERE cpmtv.transaction_id = c_Transaction_Id
763: AND cpmtv.organization_id = c_Organization_Id;
764:
765: l_proj_job_ind NUMBER;

Line 807: FROM cst_pm_matl_txn_v

803: to the source_task_id. In this case, set the cost_collected flag to
804: NULL and return. */
805: SELECT count(*)
806: INTO l_count
807: FROM cst_pm_matl_txn_v
808: WHERE transaction_id = p_transaction_id;
809:
810: IF (l_count = 0)
811: THEN