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_PAC_ITERATION_PROCESS_PVT dependencies on CST_PAC_INTORG_ITMS_TEMP

Line 216: CST_PAC_INTORG_ITMS_TEMP

212: IS
213: SELECT
214: MAX(iteration_count)
215: FROM
216: CST_PAC_INTORG_ITMS_TEMP
217: WHERE pac_period_id = c_period_id
218: AND inventory_item_id = c_inventory_item_id
219: AND tolerance_flag = 'N';
220:

Line 891: CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_intorg_itms_temp cpiit

887: , ccit.transfer_transaction_id transfer_transaction_id
888: , ccit.cost_group_id cost_group_id
889: , ccit.txn_type txn_type
890: FROM
891: CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_intorg_itms_temp cpiit
892: WHERE ccit.inventory_item_id = c_inventory_item_id
893: AND ccit.pac_period_id = c_period_id
894: AND cpiit.inventory_item_id = ccit.inventory_item_id
895: AND cpiit.cost_group_id = ccit.cost_group_id

Line 1927: FROM cst_pac_intorg_itms_temp cpiit

1923: WHERE mpacdt.pac_period_id = p_pac_period_id
1924: AND mpacdt.inventory_item_id = p_inventory_item_id
1925: AND mpacdt.cost_group_id = nvl(p_cost_group_id, mpacdt.cost_group_id)
1926: AND EXISTS (SELECT 'X'
1927: FROM cst_pac_intorg_itms_temp cpiit
1928: WHERE cpiit.pac_period_id = mpacdt.pac_period_id
1929: AND cpiit.inventory_item_id = mpacdt.inventory_item_id
1930: AND cpiit.cost_group_id = mpacdt.cost_group_id
1931: AND cpiit.diverging_flag = 'N'

Line 1993: FROM mtl_pac_actual_cost_details mpacd, cst_pac_intorg_itms_temp cpiit

1989: DISTINCT mpacd.cost_layer_id
1990: , mpacd.cost_group_id
1991: , mpacd.cost_element_id
1992: , mpacd.level_type
1993: FROM mtl_pac_actual_cost_details mpacd, cst_pac_intorg_itms_temp cpiit
1994: WHERE cpiit.pac_period_id = c_pac_period_id
1995: AND cpiit.inventory_item_id = c_inventory_item_id
1996: AND cpiit.cost_group_id = nvl(c_cost_group_id, cpiit.cost_group_id)
1997: AND cpiit.diverging_flag = 'N'

Line 2014: FROM cst_pac_intorg_itms_temp

2010: ,c_pac_period_id NUMBER
2011: )
2012: IS
2013: SELECT cost_group_id
2014: FROM cst_pac_intorg_itms_temp
2015: WHERE inventory_item_id = c_item_id
2016: AND pac_period_id = c_pac_period_id
2017: AND diverging_flag = 'N'
2018: AND interorg_receipt_flag = 'Y';

Line 2520: FROM cst_pac_intorg_itms_temp

2516: SELECT
2517: cost_group_id
2518: , prev_itr_item_cost
2519: , item_cost
2520: FROM cst_pac_intorg_itms_temp
2521: WHERE inventory_item_id = c_item_id
2522: AND pac_period_id = c_pac_period_id
2523: AND interorg_receipt_flag = 'Y'
2524: AND DIVERGING_FLAG = 'N'

Line 3288: INSERT INTO CST_PAC_INTORG_ITMS_TEMP

3284: -- ==============================================================
3285: -- Get Interorg Items with no completion
3286: -- Set low level code to 1000
3287: -- ==============================================================
3288: INSERT INTO CST_PAC_INTORG_ITMS_TEMP
3289: ( INVENTORY_ITEM_ID
3290: , COST_GROUP_ID
3291: , PAC_PERIOD_ID
3292: , ITEM_COST

Line 3329: INSERT INTO CST_PAC_INTORG_ITMS_TEMP

3325: AND cpllc.cost_group_id = p_cost_group_id);
3326:
3327:
3328:
3329: INSERT INTO CST_PAC_INTORG_ITMS_TEMP
3330: ( INVENTORY_ITEM_ID
3331: , COST_GROUP_ID
3332: , PAC_PERIOD_ID
3333: , ITEM_COST

Line 3364: FROM cst_pac_intorg_itms_temp cpiit

3360: AND ccit.pac_period_id = p_period_id
3361: AND ccit.txn_type = 2
3362: AND NOT EXISTS (
3363: SELECT 'X'
3364: FROM cst_pac_intorg_itms_temp cpiit
3365: WHERE cpiit.cost_group_id = p_cost_group_id
3366: AND cpiit.pac_period_id = p_period_id
3367: AND cpiit.inventory_item_id = ccit.inventory_item_id)
3368: AND NOT EXISTS (

Line 3380: INSERT INTO CST_PAC_INTORG_ITMS_TEMP

3376: -- ==============================================================
3377: -- Get Interorg Items with completion
3378: -- ==============================================================
3379:
3380: INSERT INTO CST_PAC_INTORG_ITMS_TEMP
3381: ( INVENTORY_ITEM_ID
3382: , COST_GROUP_ID
3383: , PAC_PERIOD_ID
3384: , ITEM_COST

Line 3415: INSERT INTO CST_PAC_INTORG_ITMS_TEMP

3411: AND cpllc.inventory_item_id = ccit.inventory_item_id
3412: AND cpllc.pac_period_id = p_period_id
3413: AND cpllc.cost_group_id = p_cost_group_id;
3414:
3415: INSERT INTO CST_PAC_INTORG_ITMS_TEMP
3416: ( INVENTORY_ITEM_ID
3417: , COST_GROUP_ID
3418: , PAC_PERIOD_ID
3419: , ITEM_COST

Line 3453: FROM cst_pac_intorg_itms_temp cpiit

3449: AND cpllc.pac_period_id = p_period_id
3450: AND cpllc.cost_group_id = p_cost_group_id
3451: AND NOT EXISTS (
3452: SELECT 'X'
3453: FROM cst_pac_intorg_itms_temp cpiit
3454: WHERE cpiit.cost_group_id = p_cost_group_id
3455: AND cpiit.pac_period_id = p_period_id
3456: AND cpiit.inventory_item_id = ccit.inventory_item_id);
3457:

Line 3459: UPDATE CST_PAC_INTORG_ITMS_TEMP cpiit

3455: AND cpiit.pac_period_id = p_period_id
3456: AND cpiit.inventory_item_id = ccit.inventory_item_id);
3457:
3458:
3459: UPDATE CST_PAC_INTORG_ITMS_TEMP cpiit
3460: SET (INTERORG_SHIPMENT_FLAG,
3461: SEQUENCE_NUM) = (select (case when exists(select 'X'
3462: from CST_PAC_INTERORG_TXNS_TMP ccit
3463: where ccit.pac_period_id = p_period_id

Line 3520: update cst_pac_intorg_itms_temp cos1

3516: -- Cost groups with across CG interorg txns are arranged in increasing order of sequence_num, On hand quantity
3517: -- for each inventory item and sequence_num is updated to reflect this order.
3518: -- The inner select query Q selects item, cost group, new sequence number.
3519:
3520: update cst_pac_intorg_itms_temp cos1
3521: set cos1.sequence_num =
3522: (select sequence_num
3523: from (select cos.inventory_item_id inventory_item_id,
3524: cos.cost_group_id cost_group_id,

Line 3530: FROM cst_pac_item_costs cpic, cst_pac_intorg_itms_temp cos

3526: row_number() over (partition by cos.inventory_item_id order by cos.sequence_num
3527: ,nvl(cpic.total_layer_quantity,0)
3528: ,cos.cost_group_id
3529: ) sequence_num
3530: FROM cst_pac_item_costs cpic, cst_pac_intorg_itms_temp cos
3531: WHERE cpic.inventory_item_id(+) = cos.inventory_item_id
3532: AND cpic.cost_group_id(+) = cos.cost_group_id
3533: AND cpic.pac_period_id(+) = cos.pac_period_id
3534: AND cos.pac_period_id = p_period_id) Q

Line 4153: UPDATE CST_PAC_INTORG_ITMS_TEMP

4149: o_err_code => l_error_code,
4150: o_err_msg => l_error_msg );
4151:
4152: -- Set PWAC Item Cost in interorg items temp table
4153: UPDATE CST_PAC_INTORG_ITMS_TEMP
4154: SET item_cost = (SELECT nvl(item_cost,0)
4155: FROM cst_pac_item_costs cpic
4156: WHERE cpic.pac_period_id = p_period_id
4157: AND cpic.cost_group_id = p_cost_group_id

Line 4768: FROM CST_PAC_INTORG_ITMS_TEMP

4764: IS
4765: SELECT
4766: nvl(item_cost,0),
4767: nvl(difference,0)
4768: FROM CST_PAC_INTORG_ITMS_TEMP
4769: WHERE pac_period_id = c_pac_period_id
4770: AND cost_group_id = c_cost_group_id
4771: AND inventory_item_id = c_inventory_item_id;
4772:

Line 5260: UPDATE CST_PAC_INTORG_ITMS_TEMP

5256: ,p_cost_group_id => p_cost_group_id
5257: ,p_cost_type_id => p_cost_type_id
5258: ,p_end_date => p_period_end_date
5259: );
5260: UPDATE CST_PAC_INTORG_ITMS_TEMP
5261: SET DIVERGING_FLAG = 'Y',
5262: TOLERANCE_FLAG = 'Y',
5263: ITERATION_COUNT = p_iteration_num
5264: WHERE pac_period_id = p_period_id

Line 5276: UPDATE CST_PAC_INTORG_ITMS_TEMP

5272: -- Set current iteration PMAC Item Cost in interorg items temp table
5273: -- assigned to item_cost
5274: -- Set previous iteration PMAC Item Cost in interorg items temp table
5275: -- assigned to previous iteration item cost
5276: UPDATE CST_PAC_INTORG_ITMS_TEMP
5277: SET prev_itr_item_cost = l_prev_itr_item_cost
5278: ,item_cost = l_pwac_item_cost
5279: ,difference = l_new_difference
5280: WHERE pac_period_id = p_period_id

Line 5455: FROM cst_pac_intorg_itms_temp

5451: cost_group_id
5452: , interorg_receipt_flag
5453: , interorg_shipment_flag
5454: , low_level_code
5455: FROM cst_pac_intorg_itms_temp
5456: WHERE inventory_item_id = c_item_id
5457: AND pac_period_id = c_pac_period_id
5458: AND diverging_flag = 'N'
5459: ORDER BY sequence_num;

Line 5693: from cst_pac_intorg_itms_temp

5689:
5690: DELETE FROM mtl_pac_actual_cost_details mpacd
5691: WHERE mpacd.pac_period_id = p_period_id
5692: AND EXISTS (select 'X'
5693: from cst_pac_intorg_itms_temp
5694: where cost_group_id = mpacd.cost_group_id
5695: and inventory_item_id = l_inventory_item_id
5696: and pac_period_id = p_period_id
5697: and interorg_receipt_flag = 'Y')

Line 5784: UPDATE CST_PAC_INTORG_ITMS_TEMP

5780: -- tolerance; 4 - Final
5781: -- =====================================================================
5782: IF l_tolerance_flag = 'Y' THEN
5783:
5784: UPDATE CST_PAC_INTORG_ITMS_TEMP
5785: SET tolerance_flag = l_tolerance_flag
5786: ,iteration_count = l_iteration_num
5787: WHERE inventory_item_id = l_inventory_item_id
5788: AND pac_period_id = p_period_id

Line 5842: UPDATE CST_PAC_INTORG_ITMS_TEMP

5838: END IF;
5839:
5840: -- Update tolerance flag and final iteration number for this item
5841: -- Set flag to 'F' - Finalized
5842: UPDATE CST_PAC_INTORG_ITMS_TEMP
5843: SET tolerance_flag = 'F'
5844: ,iteration_count = l_end_iteration_num
5845: WHERE pac_period_id = p_period_id
5846: AND inventory_item_id = l_inventory_item_id

Line 5871: UPDATE CST_PAC_INTORG_ITMS_TEMP

5867: -- Update iteration count for the interorg item
5868: -- it is required to store the iteration count which
5869: -- is mainly used in the next iteration process
5870: -- ===========================================================
5871: UPDATE CST_PAC_INTORG_ITMS_TEMP
5872: SET iteration_count = l_end_iteration_num
5873: WHERE pac_period_id = p_period_id
5874: AND tolerance_flag = 'N'
5875: AND inventory_item_id = l_inventory_item_id