DBA Data[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on CST_INVENTORY_PVT

Line 1: PACKAGE BODY CST_Inventory_PVT AS

1: PACKAGE BODY CST_Inventory_PVT AS
2: /* $Header: CSTVIVTB.pls 120.33.12020000.4 2013/03/29 13:16:17 nmogili ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_Inventory_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_Inventory_PVT';

1: PACKAGE BODY CST_Inventory_PVT AS
2: /* $Header: CSTVIVTB.pls 120.33.12020000.4 2013/03/29 13:16:17 nmogili ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_Inventory_PVT';
5:
6: g_mrp_debug VARCHAR2(1) := NVL(FND_PROFILE.Value('MRP_DEBUG'),'N');
7:
8: g_cost_type_id NUMBER := NULL;

Line 785: CST_Inventory_PVT.g_run_onhand_date := SYSDATE;

781:
782: -- Calculate Current Onhand Quantity
783: l_stmt_num := 10;
784: /* Initialize g_run_onhand_date */
785: CST_Inventory_PVT.g_run_onhand_date := SYSDATE;
786: INSERT
787: INTO cst_inv_qty_temp(
788: organization_id,
789: cost_group_id,

Line 815: AND MOQ.last_update_date <= NVL(CST_Inventory_PVT.g_run_onhand_date,MOQ.last_update_date)

811: WHERE MOQ.organization_id = p_organization_id
812: AND CILT.inventory_item_id = MOQ.inventory_item_id
813: AND CCLT.cost_group_id = MOQ.cost_group_id
814: AND CSLT.subinventory_code = MOQ.subinventory_code
815: AND MOQ.last_update_date <= NVL(CST_Inventory_PVT.g_run_onhand_date,MOQ.last_update_date)
816: GROUP
817: BY MOQ.cost_group_id,
818: MOQ.subinventory_code,
819: MOQ.inventory_item_id,

Line 882: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_onhand_date,MMT.creation_date)

878: AND NVL(MMT.logical_transaction,-1) <> 1
879: -- Ignore WMS/OSFM transactions, cost updates including periodic cost
880: -- updates that do not affect onhand quantity
881: AND MMT.transaction_action_id NOT IN (24,40,41,50,51,52)
882: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_onhand_date,MMT.creation_date)
883: GROUP
884: BY MMT.cost_group_id,
885: MMT.subinventory_code,
886: MMT.inventory_item_id,

Line 953: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_onhand_date,MMT.creation_date)

949: cst_item_list_temp CILT
950: WHERE MMT.organization_id = p_organization_id
951: AND CILT.inventory_item_id = MMT.inventory_item_id
952: AND MMT.costed_flag IS NULL
953: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_onhand_date,MMT.creation_date)
954: AND MMT.transaction_date > p_valuation_date
955: -- Ignore Consigned transactions
956: AND MMT.organization_id = NVL(MMT.owning_organization_id,
957: MMT.organization_id)

Line 1182: CST_Inventory_PVT.g_run_incmng_intransit_date := SYSDATE;

1178: THEN
1179: -- Calculate current intransit quantity coming into this organization
1180: l_stmt_num := 10;
1181: /*Initialize g_run_incmng_intransit_date */
1182: CST_Inventory_PVT.g_run_incmng_intransit_date := SYSDATE;
1183: INSERT
1184: INTO cst_inv_qty_temp(
1185: qty_source,
1186: organization_id,

Line 1253: AND MS.last_update_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MS.last_update_date)

1249: MS.to_organization_id, 1
1250: )
1251: AND MSI_FROM.inventory_item_id = MS.item_id
1252: AND MSI_FROM.organization_id = MS.from_organization_id
1253: AND MS.last_update_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MS.last_update_date)
1254: GROUP
1255: BY MS.intransit_owning_org_id,
1256: ITEMS.inventory_item_id,
1257: ITEMS.category_id,

Line 1350: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)

1346: AND MSI_TO.inventory_item_id = MMT.inventory_item_id
1347: AND RSH.shipment_num = MMT.shipment_number
1348: AND RSL.shipment_header_id = RSH.shipment_header_id
1349: AND RSL.mmt_transaction_id = Decode(MMT.transaction_action_id, 21, MMT.transaction_id, 15, MMT.parent_transaction_id)
1350: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)
1351: GROUP
1352: BY DECODE(
1353: NVL(MMT.fob_point,MIP.fob_point),
1354: 1,Decode(MMT.transaction_action_id, 21, MMT.transfer_organization_id, 15, MMT.organization_id),

Line 1440: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)

1436: AND MIP.from_organization_id = MMT.transfer_organization_id
1437: AND MSI_FROM.organization_id = MMT.transfer_organization_id
1438: AND MSI_FROM.inventory_item_id = MMT.inventory_item_id
1439: AND RT.transaction_id = MMT.rcv_transaction_id
1440: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)
1441: GROUP
1442: BY DECODE(
1443: NVL(MMT.fob_point,MIP.fob_point),
1444: 1,MMT.organization_id,

Line 1554: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)

1550: AND MSI_TO.inventory_item_id = MMT.inventory_item_id
1551: AND RSH.shipment_num = MMT.shipment_number
1552: AND RSL.shipment_header_id = RSH.shipment_header_id
1553: AND RSL.mmt_transaction_id = MMT.transaction_id
1554: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)
1555: GROUP
1556: BY DECODE(
1557: NVL(MMT.fob_point,MIP.fob_point),
1558: 1,MMT.transfer_organization_id,

Line 1649: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)

1645: AND MIP.from_organization_id = MMT.transfer_organization_id
1646: AND MSI_FROM.organization_id = MMT.transfer_organization_id
1647: AND MSI_FROM.inventory_item_id = MMT.inventory_item_id
1648: AND RT.transaction_id = MMT.rcv_transaction_id
1649: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)
1650: GROUP
1651: BY DECODE(
1652: NVL(MMT.fob_point,MIP.fob_point),
1653: 1,MMT.organization_id,

Line 1688: CST_Inventory_PVT.g_run_outgng_intransit_date := SYSDATE;

1684: -- p_organization_id, we check for MS.from_organization_id =
1685: -- p_organization_id
1686: l_stmt_num := 60;
1687: /*Initialize g_run_outgng_intransit_date */
1688: CST_Inventory_PVT.g_run_outgng_intransit_date := SYSDATE;
1689: INSERT
1690: INTO cst_inv_qty_temp(
1691: qty_source,
1692: organization_id,

Line 1756: AND MS.last_update_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MS.last_update_date)

1752: MS.from_organization_id, 2,
1753: MS.to_organization_id, 1)
1754: AND MSI_FROM.inventory_item_id = MS.item_id
1755: AND MSI_FROM.organization_id = MS.from_organization_id
1756: AND MS.last_update_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MS.last_update_date)
1757: GROUP
1758: BY MS.intransit_owning_org_id,
1759: ITEMS.inventory_item_id,
1760: ITEMS.category_id,

Line 1856: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)

1852: AND MSI_TO.inventory_item_id = MMT.inventory_item_id
1853: AND RSH.shipment_num = MMT.shipment_number
1854: AND RSL.shipment_header_id = RSH.shipment_header_id
1855: AND RSL.mmt_transaction_id = MMT.transaction_id
1856: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)
1857: GROUP
1858: BY DECODE(
1859: NVL(MMT.fob_point,MIP.fob_point),
1860: 1,MMT.transfer_organization_id,

Line 1951: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)

1947: AND MIP.from_organization_id = Decode(MMT.transaction_action_id, 12, MMT.transfer_organization_id, 22, MMT.organization_id)
1948: AND MSI_FROM.organization_id = Decode(MMT.transaction_action_id, 12, MMT.transfer_organization_id, 22, MMT.organization_id)
1949: AND MSI_FROM.inventory_item_id = MMT.inventory_item_id
1950: AND RT.transaction_id = MMT.rcv_transaction_id
1951: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)
1952: GROUP
1953: BY DECODE(
1954: NVL(MMT.fob_point,MIP.fob_point),
1955: 1,MMT.organization_id,

Line 2053: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)

2049: AND MSI_TO.inventory_item_id = MMT.inventory_item_id
2050: AND RSH.shipment_num = MMT.shipment_number
2051: AND RSL.shipment_header_id = RSH.shipment_header_id
2052: AND RSL.mmt_transaction_id = MMT.transaction_id
2053: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)
2054: GROUP
2055: BY DECODE(
2056: NVL(MMT.fob_point,MIP.fob_point),
2057: 1,MMT.transfer_organization_id,

Line 2161: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)

2157: AND MIP.from_organization_id = MMT.transfer_organization_id
2158: AND MSI_FROM.organization_id = MMT.transfer_organization_id
2159: AND MSI_FROM.inventory_item_id = MMT.inventory_item_id
2160: AND RT.transaction_id = MMT.rcv_transaction_id
2161: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)
2162: GROUP
2163: BY DECODE(
2164: NVL(MMT.fob_point,MIP.fob_point),
2165: 1,MMT.organization_id,

Line 2205: CST_Inventory_PVT.g_run_incmng_intransit_date := SYSDATE;

2201: THEN
2202: -- Calculate current intransit quantity coming into this organization
2203: l_stmt_num := 110;
2204: /*Initialize g_run_incmng_intransit_date */
2205: CST_Inventory_PVT.g_run_incmng_intransit_date := SYSDATE;
2206: INSERT
2207: INTO cst_inv_qty_temp(
2208: qty_source,
2209: organization_id,

Line 2274: AND MS.last_update_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MS.last_update_date)

2270: MS.to_organization_id, 1
2271: )
2272: AND MSI_FROM.inventory_item_id = MS.item_id
2273: AND MSI_FROM.organization_id = MS.from_organization_id
2274: AND MS.last_update_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MS.last_update_date)
2275: GROUP
2276: BY MS.intransit_owning_org_id,
2277: ITEMS.inventory_item_id,
2278: ITEMS.category_id,

Line 2361: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)

2357: AND MIP.to_organization_id = Decode(MMT.transaction_action_id, 21, MMT.transfer_organization_id, 15, MMT.organization_id)
2358: AND MIP.from_organization_id = Decode(MMT.transaction_action_id, 21, MMT.organization_id, 15, MMT.transfer_organization_id)
2359: AND MSI_TO.organization_id = Decode(MMT.transaction_action_id, 21, MMT.transfer_organization_id, 15, MMT.organization_id)
2360: AND MSI_TO.inventory_item_id = MMT.inventory_item_id
2361: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)
2362: GROUP
2363: BY DECODE(
2364: NVL(MMT.fob_point,MIP.fob_point),
2365: 1,Decode(MMT.transaction_action_id, 21, MMT.transfer_organization_id, 15, MMT.organization_id),

Line 2446: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)

2442: AND MIP.to_organization_id = MMT.organization_id
2443: AND MIP.from_organization_id = MMT.transfer_organization_id
2444: AND MSI_FROM.organization_id = MMT.transfer_organization_id
2445: AND MSI_FROM.inventory_item_id = MMT.inventory_item_id
2446: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)
2447: GROUP
2448: BY DECODE(
2449: NVL(MMT.fob_point,MIP.fob_point),
2450: 1,MMT.organization_id,

Line 2556: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)

2552: AND MSI_TO.inventory_item_id = MMT.inventory_item_id
2553: AND MTT.transaction_action_id = MMT.transaction_action_id
2554: AND MTT.transaction_source_type_id = MMT.transaction_source_type_id
2555: AND MTT.transaction_type_id = MMT.transaction_type_id
2556: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)
2557: GROUP
2558: BY DECODE(
2559: NVL(MMT.fob_point,MIP.fob_point),
2560: 1,MMT.transfer_organization_id,

Line 2650: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)

2646: AND MSI_FROM.inventory_item_id = MMT.inventory_item_id
2647: AND MTT.transaction_action_id = MMT.transaction_action_id
2648: AND MTT.transaction_source_type_id = MMT.transaction_source_type_id
2649: AND MTT.transaction_type_id = MMT.transaction_type_id
2650: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,MMT.creation_date)
2651: GROUP
2652: BY DECODE(
2653: NVL(MMT.fob_point,MIP.fob_point),
2654: 1,MMT.organization_id,

Line 2688: CST_Inventory_PVT.g_run_outgng_intransit_date := SYSDATE;

2684: -- p_organization_id, we check for MS.from_organization_id =
2685: -- p_organization_id
2686: l_stmt_num := 60;
2687: /* Initialize g_run_outgng_intransit_date */
2688: CST_Inventory_PVT.g_run_outgng_intransit_date := SYSDATE;
2689: INSERT
2690: INTO cst_inv_qty_temp(
2691: qty_source,
2692: organization_id,

Line 2754: AND MS.last_update_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MS.last_update_date)

2750: MS.from_organization_id, 2,
2751: MS.to_organization_id, 1)
2752: AND MSI_FROM.inventory_item_id = MS.item_id
2753: AND MSI_FROM.organization_id = MS.from_organization_id
2754: AND MS.last_update_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MS.last_update_date)
2755: GROUP
2756: BY MS.intransit_owning_org_id,
2757: ITEMS.inventory_item_id,
2758: ITEMS.category_id,

Line 2844: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)

2840: AND MIP.to_organization_id = MMT.transfer_organization_id
2841: AND MIP.from_organization_id = MMT.organization_id
2842: AND MSI_TO.organization_id = MMT.transfer_organization_id
2843: AND MSI_TO.inventory_item_id = MMT.inventory_item_id
2844: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)
2845: GROUP
2846: BY DECODE(
2847: NVL(MMT.fob_point,MIP.fob_point),
2848: 1,MMT.transfer_organization_id,

Line 2934: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)

2930: AND MIP.to_organization_id = Decode(MMT.transaction_action_id, 12, MMT.organization_id, 22, MMT.transfer_organization_id)
2931: AND MIP.from_organization_id = Decode(MMT.transaction_action_id, 12, MMT.transfer_organization_id, 22, MMT.organization_id)
2932: AND MSI_FROM.organization_id = Decode(MMT.transaction_action_id, 12, MMT.transfer_organization_id, 22, MMT.organization_id)
2933: AND MSI_FROM.inventory_item_id = MMT.inventory_item_id
2934: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)
2935: GROUP
2936: BY DECODE(
2937: NVL(MMT.fob_point,MIP.fob_point),
2938: 1,MMT.organization_id,

Line 3033: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)

3029: AND MSI_TO.inventory_item_id = MMT.inventory_item_id
3030: AND MTT.transaction_action_id = MMT.transaction_action_id
3031: AND MTT.transaction_source_type_id = MMT.transaction_source_type_id
3032: AND MTT.transaction_type_id = MMT.transaction_type_id
3033: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)
3034: GROUP
3035: BY DECODE(
3036: NVL(MMT.fob_point,MIP.fob_point),
3037: 1,MMT.transfer_organization_id,

Line 3140: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)

3136: AND MSI_FROM.inventory_item_id = MMT.inventory_item_id
3137: AND MTT.transaction_action_id = MMT.transaction_action_id
3138: AND MTT.transaction_source_type_id = MMT.transaction_source_type_id
3139: AND MTT.transaction_type_id = MMT.transaction_type_id
3140: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,MMT.creation_date)
3141: GROUP
3142: BY DECODE(
3143: NVL(MMT.fob_point,MIP.fob_point),
3144: 1,MMT.organization_id,

Line 3245: CST_Inventory_PVT.g_run_receiving_date := SYSDATE;

3241: -- the parent RECEIVE or MATCH with the exception of cases in which
3242: -- there was an Accept/Reject/Transfer transaction.
3243: l_stmt_num := 10;
3244: /*Initialize g_run_receiving_date */
3245: CST_Inventory_PVT.g_run_receiving_date := SYSDATE;
3246: INSERT
3247: INTO cst_inv_qty_temp(
3248: qty_source,
3249: organization_id,

Line 3296: AND RT.creation_date <= NVL(CST_Inventory_PVT.g_run_receiving_date,RT.creation_date)

3292: AND POLL.line_location_id = RT.po_line_location_id
3293: AND POLL.shipment_type <> 'PREPAYMENT'
3294: AND POLL.matching_basis = 'QUANTITY' -- eliminate service line types
3295: AND POLL.accrue_on_receipt_flag = DECODE(p_include_period_end, 1, POLL.accrue_on_receipt_flag, 'Y')
3296: AND RT.creation_date <= NVL(CST_Inventory_PVT.g_run_receiving_date,RT.creation_date)
3297: GROUP
3298: BY MS.to_organization_id,
3299: CILT.inventory_item_id,
3300: DECODE(MS.item_id, NULL, POL.category_id, CILT.category_id),

Line 3404: AND RT.creation_date <= NVL(CST_Inventory_PVT.g_run_receiving_date,RT.creation_date)

3400: AND POLL.line_location_id = RT.po_line_location_id
3401: AND POLL.shipment_type <> 'PREPAYMENT'
3402: AND POLL.matching_basis = 'QUANTITY' -- eliminate service line types
3403: AND POLL.accrue_on_receipt_flag = DECODE(p_include_period_end, 1, POLL.accrue_on_receipt_flag, 'Y')
3404: AND RT.creation_date <= NVL(CST_Inventory_PVT.g_run_receiving_date,RT.creation_date)
3405: GROUP
3406: BY RT.organization_id,
3407: CILT.inventory_item_id,
3408: DECODE(POL.item_id, NULL, POL.category_id, CILT.category_id),

Line 3602: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_onhand_date,MMT.creation_date)

3598: --
3599: AND NOT (mmt.transaction_action_id = 24 AND mmt.transaction_source_type_id <> 11)
3600: AND MMT.inventory_item_id = p_inventory_item_id
3601: AND MMT.organization_id = p_organization_id
3602: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_onhand_date,MMT.creation_date)
3603: AND mmt.transaction_id = mcacd.transaction_id (+) )
3604: ORDER BY TXN_DATE asc,
3605: mmt_txn asc;
3606:

Line 4473: where ( ( MMT.creation_date <= NVL(NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,

4469: where from_organization_id = p_organization_id
4470: or to_organization_id = p_organization_id) MIP,
4471: MTL_MATERIAL_TRANSACTIONS MMT,
4472: MTL_CST_ACTUAL_COST_DETAILS MCACD
4473: where ( ( MMT.creation_date <= NVL(NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,
4474: CST_Inventory_PVT.g_run_onhand_date),
4475: MMT.creation_date)
4476: AND MMT.transaction_action_id = 21
4477: )

Line 4474: CST_Inventory_PVT.g_run_onhand_date),

4470: or to_organization_id = p_organization_id) MIP,
4471: MTL_MATERIAL_TRANSACTIONS MMT,
4472: MTL_CST_ACTUAL_COST_DETAILS MCACD
4473: where ( ( MMT.creation_date <= NVL(NVL(CST_Inventory_PVT.g_run_incmng_intransit_date,
4474: CST_Inventory_PVT.g_run_onhand_date),
4475: MMT.creation_date)
4476: AND MMT.transaction_action_id = 21
4477: )
4478: OR ( MMT.creation_date <= NVL(NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,

Line 4478: OR ( MMT.creation_date <= NVL(NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,

4474: CST_Inventory_PVT.g_run_onhand_date),
4475: MMT.creation_date)
4476: AND MMT.transaction_action_id = 21
4477: )
4478: OR ( MMT.creation_date <= NVL(NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,
4479: CST_Inventory_PVT.g_run_onhand_date),
4480: MMT.creation_date)
4481: AND MMT.transaction_action_id = 12
4482: )

Line 4479: CST_Inventory_PVT.g_run_onhand_date),

4475: MMT.creation_date)
4476: AND MMT.transaction_action_id = 21
4477: )
4478: OR ( MMT.creation_date <= NVL(NVL(CST_Inventory_PVT.g_run_outgng_intransit_date,
4479: CST_Inventory_PVT.g_run_onhand_date),
4480: MMT.creation_date)
4481: AND MMT.transaction_action_id = 12
4482: )
4483: )

Line 4511: where MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_onhand_date,MMT.creation_date)

4507: MMT.inventory_item_id,
4508: MCACD.organization_id
4509: from MTL_MATERIAL_TRANSACTIONS MMT,
4510: MTL_CST_ACTUAL_COST_DETAILS MCACD
4511: where MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_onhand_date,MMT.creation_date)
4512: AND MMT.costed_flag is null
4513: AND MMT.transaction_action_id not in (5,30,40,41,42,43,50,51,52,11,17,10,13,9,14,7,26,36,25,56,57)
4514: AND NOT (MMT.transaction_action_id IN (2,28,55) AND MMT.primary_quantity > 0)
4515: AND NOT (MMT.transaction_action_id = 24 and MMT.transaction_source_type_id = 14)

Line 4755: END CST_Inventory_PVT;

4751: );
4752: END IF;
4753: END Calculate_InventoryCost;
4754:
4755: END CST_Inventory_PVT;