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 897: CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_intorg_itms_temp cpiit

893: , ccit.transfer_transaction_id transfer_transaction_id
894: , ccit.cost_group_id cost_group_id
895: , ccit.txn_type txn_type
896: FROM
897: CST_PAC_INTERORG_TXNS_TMP ccit, cst_pac_intorg_itms_temp cpiit
898: WHERE ccit.inventory_item_id = c_inventory_item_id
899: AND ccit.pac_period_id = c_period_id
900: AND cpiit.inventory_item_id = ccit.inventory_item_id
901: AND cpiit.cost_group_id = ccit.cost_group_id

Line 943: FROM cst_pac_intorg_itms_temp

939: IS
940: SELECT
941: interorg_receipt_flag
942: , interorg_shipment_flag
943: FROM cst_pac_intorg_itms_temp
944: WHERE pac_period_id = c_period_id
945: AND cost_group_id = c_opp_cost_group_id
946: AND inventory_item_id = c_inventory_item_id;
947:

Line 2048: FROM cst_pac_intorg_itms_temp cpiit

2044: WHERE mpacdt.pac_period_id = p_pac_period_id
2045: AND mpacdt.inventory_item_id = p_inventory_item_id
2046: AND mpacdt.cost_group_id = nvl(p_cost_group_id, mpacdt.cost_group_id)
2047: AND EXISTS (SELECT 'X'
2048: FROM cst_pac_intorg_itms_temp cpiit
2049: WHERE cpiit.pac_period_id = mpacdt.pac_period_id
2050: AND cpiit.inventory_item_id = mpacdt.inventory_item_id
2051: AND cpiit.cost_group_id = mpacdt.cost_group_id
2052: AND cpiit.diverging_flag = 'N'

Line 2119: FROM mtl_pac_actual_cost_details mpacd, cst_pac_intorg_itms_temp cpiit

2115: DISTINCT mpacd.cost_layer_id
2116: , mpacd.cost_group_id
2117: , mpacd.cost_element_id
2118: , mpacd.level_type
2119: FROM mtl_pac_actual_cost_details mpacd, cst_pac_intorg_itms_temp cpiit
2120: WHERE cpiit.pac_period_id = c_pac_period_id
2121: AND cpiit.inventory_item_id = c_inventory_item_id
2122: AND cpiit.cost_group_id = nvl(c_cost_group_id, cpiit.cost_group_id)
2123: AND cpiit.diverging_flag = 'N'

Line 2140: FROM cst_pac_intorg_itms_temp

2136: ,c_pac_period_id NUMBER
2137: )
2138: IS
2139: SELECT cost_group_id
2140: FROM cst_pac_intorg_itms_temp
2141: WHERE inventory_item_id = c_item_id
2142: AND pac_period_id = c_pac_period_id
2143: AND diverging_flag = 'N'
2144: AND interorg_receipt_flag = 'Y';

Line 2665: FROM cst_pac_intorg_itms_temp

2661: SELECT
2662: cost_group_id
2663: , prev_itr_item_cost
2664: , item_cost
2665: FROM cst_pac_intorg_itms_temp
2666: WHERE inventory_item_id = c_item_id
2667: AND pac_period_id = c_pac_period_id
2668: AND interorg_receipt_flag = 'Y'
2669: AND interorg_shipment_flag = 'Y'

Line 3444: INSERT INTO CST_PAC_INTORG_ITMS_TEMP

3440: -- ==============================================================
3441: -- Get Interorg Items with no completion
3442: -- Set low level code to 1000
3443: -- ==============================================================
3444: INSERT INTO CST_PAC_INTORG_ITMS_TEMP
3445: ( INVENTORY_ITEM_ID
3446: , COST_GROUP_ID
3447: , PAC_PERIOD_ID
3448: , ITEM_COST

Line 3485: INSERT INTO CST_PAC_INTORG_ITMS_TEMP

3481: AND cpllc.cost_group_id = p_cost_group_id);
3482:
3483:
3484:
3485: INSERT INTO CST_PAC_INTORG_ITMS_TEMP
3486: ( INVENTORY_ITEM_ID
3487: , COST_GROUP_ID
3488: , PAC_PERIOD_ID
3489: , ITEM_COST

Line 3520: FROM cst_pac_intorg_itms_temp cpiit

3516: AND ccit.pac_period_id = p_period_id
3517: AND ccit.txn_type = 2
3518: AND NOT EXISTS (
3519: SELECT 'X'
3520: FROM cst_pac_intorg_itms_temp cpiit
3521: WHERE cpiit.cost_group_id = p_cost_group_id
3522: AND cpiit.pac_period_id = p_period_id
3523: AND cpiit.inventory_item_id = ccit.inventory_item_id)
3524: AND NOT EXISTS (

Line 3536: INSERT INTO CST_PAC_INTORG_ITMS_TEMP

3532: -- ==============================================================
3533: -- Get Interorg Items with completion
3534: -- ==============================================================
3535:
3536: INSERT INTO CST_PAC_INTORG_ITMS_TEMP
3537: ( INVENTORY_ITEM_ID
3538: , COST_GROUP_ID
3539: , PAC_PERIOD_ID
3540: , ITEM_COST

Line 3571: INSERT INTO CST_PAC_INTORG_ITMS_TEMP

3567: AND cpllc.inventory_item_id = ccit.inventory_item_id
3568: AND cpllc.pac_period_id = p_period_id
3569: AND cpllc.cost_group_id = p_cost_group_id;
3570:
3571: INSERT INTO CST_PAC_INTORG_ITMS_TEMP
3572: ( INVENTORY_ITEM_ID
3573: , COST_GROUP_ID
3574: , PAC_PERIOD_ID
3575: , ITEM_COST

Line 3609: FROM cst_pac_intorg_itms_temp cpiit

3605: AND cpllc.pac_period_id = p_period_id
3606: AND cpllc.cost_group_id = p_cost_group_id
3607: AND NOT EXISTS (
3608: SELECT 'X'
3609: FROM cst_pac_intorg_itms_temp cpiit
3610: WHERE cpiit.cost_group_id = p_cost_group_id
3611: AND cpiit.pac_period_id = p_period_id
3612: AND cpiit.inventory_item_id = ccit.inventory_item_id);
3613:

Line 3615: UPDATE CST_PAC_INTORG_ITMS_TEMP cpiit

3611: AND cpiit.pac_period_id = p_period_id
3612: AND cpiit.inventory_item_id = ccit.inventory_item_id);
3613:
3614:
3615: UPDATE CST_PAC_INTORG_ITMS_TEMP cpiit
3616: SET (INTERORG_SHIPMENT_FLAG,
3617: SEQUENCE_NUM) = (select (case when exists(select 'X'
3618: from CST_PAC_INTERORG_TXNS_TMP ccit
3619: where ccit.pac_period_id = p_period_id

Line 3676: update cst_pac_intorg_itms_temp cos1

3672: -- Cost groups with across CG interorg txns are arranged in increasing order of sequence_num, On hand quantity
3673: -- for each inventory item and sequence_num is updated to reflect this order.
3674: -- The inner select query Q selects item, cost group, new sequence number.
3675:
3676: update cst_pac_intorg_itms_temp cos1
3677: set cos1.sequence_num =
3678: (select sequence_num
3679: from (select cos.inventory_item_id inventory_item_id,
3680: cos.cost_group_id cost_group_id,

Line 3686: FROM cst_pac_item_costs cpic, cst_pac_intorg_itms_temp cos

3682: row_number() over (partition by cos.inventory_item_id order by cos.sequence_num
3683: ,nvl(cpic.total_layer_quantity,0)
3684: ,cos.cost_group_id
3685: ) sequence_num
3686: FROM cst_pac_item_costs cpic, cst_pac_intorg_itms_temp cos
3687: WHERE cpic.inventory_item_id(+) = cos.inventory_item_id
3688: AND cpic.cost_group_id(+) = cos.cost_group_id
3689: AND cpic.pac_period_id(+) = cos.pac_period_id
3690: AND cos.pac_period_id = p_period_id) Q

Line 4386: UPDATE CST_PAC_INTORG_ITMS_TEMP

4382: o_err_code => l_error_code,
4383: o_err_msg => l_error_msg );
4384:
4385: -- Set PWAC Item Cost in interorg items temp table
4386: UPDATE CST_PAC_INTORG_ITMS_TEMP
4387: SET item_cost = (SELECT nvl(item_cost,0)
4388: FROM cst_pac_item_costs cpic
4389: WHERE cpic.pac_period_id = p_period_id
4390: AND cpic.cost_group_id = p_cost_group_id

Line 5001: FROM CST_PAC_INTORG_ITMS_TEMP

4997: IS
4998: SELECT
4999: nvl(item_cost,0),
5000: nvl(difference,0)
5001: FROM CST_PAC_INTORG_ITMS_TEMP
5002: WHERE pac_period_id = c_pac_period_id
5003: AND cost_group_id = c_cost_group_id
5004: AND inventory_item_id = c_inventory_item_id;
5005:

Line 5535: UPDATE CST_PAC_INTORG_ITMS_TEMP

5531: ,p_cost_group_id => p_cost_group_id
5532: ,p_cost_type_id => p_cost_type_id
5533: ,p_end_date => p_period_end_date
5534: );
5535: UPDATE CST_PAC_INTORG_ITMS_TEMP
5536: SET DIVERGING_FLAG = 'Y',
5537: TOLERANCE_FLAG = 'Y',
5538: ITERATION_COUNT = p_iteration_num
5539: WHERE pac_period_id = p_period_id

Line 5551: UPDATE CST_PAC_INTORG_ITMS_TEMP

5547: -- Set current iteration PMAC Item Cost in interorg items temp table
5548: -- assigned to item_cost
5549: -- Set previous iteration PMAC Item Cost in interorg items temp table
5550: -- assigned to previous iteration item cost
5551: UPDATE CST_PAC_INTORG_ITMS_TEMP
5552: SET prev_itr_item_cost = l_prev_itr_item_cost
5553: ,item_cost = l_pwac_item_cost
5554: ,difference = l_new_difference
5555: WHERE pac_period_id = p_period_id

Line 5730: FROM cst_pac_intorg_itms_temp

5726: cost_group_id
5727: , interorg_receipt_flag
5728: , interorg_shipment_flag
5729: , low_level_code
5730: FROM cst_pac_intorg_itms_temp
5731: WHERE inventory_item_id = c_item_id
5732: AND pac_period_id = c_pac_period_id
5733: AND diverging_flag = 'N'
5734: ORDER BY sequence_num;

Line 6069: UPDATE CST_PAC_INTORG_ITMS_TEMP

6065:
6066: -- Bug 7674673 fix
6067: -- Set PWAC Item Cost in interorg items temp table
6068: -- after PCU value change
6069: UPDATE CST_PAC_INTORG_ITMS_TEMP
6070: SET item_cost = (SELECT nvl(item_cost,0)
6071: FROM cst_pac_item_costs cpic
6072: WHERE cpic.pac_period_id = p_period_id
6073: AND cpic.cost_group_id = l_optimal_cg_idx.cost_group_id

Line 6199: from cst_pac_intorg_itms_temp

6195:
6196: DELETE FROM mtl_pac_actual_cost_details mpacd
6197: WHERE mpacd.pac_period_id = p_period_id
6198: AND EXISTS (select 'X'
6199: from cst_pac_intorg_itms_temp
6200: where cost_group_id = mpacd.cost_group_id
6201: and inventory_item_id = l_inventory_item_id
6202: and pac_period_id = p_period_id
6203: and interorg_receipt_flag = 'Y')

Line 6290: UPDATE CST_PAC_INTORG_ITMS_TEMP

6286: -- tolerance; 4 - Final
6287: -- =====================================================================
6288: IF l_tolerance_flag = 'Y' THEN
6289:
6290: UPDATE CST_PAC_INTORG_ITMS_TEMP
6291: SET tolerance_flag = l_tolerance_flag
6292: ,iteration_count = l_iteration_num
6293: WHERE inventory_item_id = l_inventory_item_id
6294: AND pac_period_id = p_period_id

Line 6348: UPDATE CST_PAC_INTORG_ITMS_TEMP

6344: END IF;
6345:
6346: -- Update tolerance flag and final iteration number for this item
6347: -- Set flag to 'F' - Finalized
6348: UPDATE CST_PAC_INTORG_ITMS_TEMP
6349: SET tolerance_flag = 'F'
6350: ,iteration_count = l_end_iteration_num
6351: WHERE pac_period_id = p_period_id
6352: AND inventory_item_id = l_inventory_item_id

Line 6377: UPDATE CST_PAC_INTORG_ITMS_TEMP

6373: -- Update iteration count for the interorg item
6374: -- it is required to store the iteration count which
6375: -- is mainly used in the next iteration process
6376: -- ===========================================================
6377: UPDATE CST_PAC_INTORG_ITMS_TEMP
6378: SET iteration_count = l_end_iteration_num
6379: WHERE pac_period_id = p_period_id
6380: AND tolerance_flag = 'N'
6381: AND inventory_item_id = l_inventory_item_id