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_INVENTORY_PVT dependencies on CST_INV_QTY_TEMP

Line 787: INTO cst_inv_qty_temp(

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,
790: subinventory_code,
791: inventory_item_id,

Line 839: INTO cst_inv_qty_temp(

835: l_stmt_num := 20;
836: IF NVL(p_unvalued_txns,-1) <> 1
837: THEN
838: INSERT
839: INTO cst_inv_qty_temp(
840: organization_id,
841: cost_group_id,
842: subinventory_code,
843: inventory_item_id,

Line 910: INTO cst_inv_qty_temp

906: l_stmt_num := 30;
907: IF p_valuation_date IS NOT NULL
908: THEN
909: INSERT
910: INTO cst_inv_qty_temp
911: ( organization_id,
912: cost_group_id,
913: subinventory_code,
914: inventory_item_id,

Line 1014: INTO cst_inv_qty_temp(

1010: IF p_zero_qty = 1
1011: THEN
1012: l_stmt_num := 40;
1013: INSERT
1014: INTO cst_inv_qty_temp(
1015: organization_id,
1016: inventory_item_id,
1017: rollback_qty,
1018: qty_source,

Line 1040: FROM cst_inv_qty_temp

1036: SELECT DISTINCT
1037: inventory_item_id,
1038: category_id,
1039: cost_type_id
1040: FROM cst_inv_qty_temp
1041: WHERE organization_id = p_organization_id
1042: ) TEMP,
1043: mtl_parameters MP
1044: WHERE MP.organization_id = p_organization_id;

Line 1184: INTO cst_inv_qty_temp(

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,
1187: inventory_item_id,
1188: category_id,

Line 1288: INTO cst_inv_qty_temp(

1284: IF l_uncosted_txn_count > 0 THEN --BUG6109468-FP5606455
1285:
1286: l_stmt_num := 20;
1287: INSERT
1288: INTO cst_inv_qty_temp(
1289: qty_source,
1290: organization_id,
1291: inventory_item_id,
1292: category_id,

Line 1382: INTO cst_inv_qty_temp(

1378: -- Calculate uncosted intransit receipt quantities coming into this
1379: -- organization
1380: l_stmt_num := 30;
1381: INSERT
1382: INTO cst_inv_qty_temp(
1383: qty_source,
1384: organization_id,
1385: inventory_item_id,
1386: category_id,

Line 1480: INTO cst_inv_qty_temp(

1476: -- costed_flag in ('N','E'), we check for costed_flag is NULL and
1477: -- transaction_date > p_valuation_date
1478: l_stmt_num := 40;
1479: INSERT
1480: INTO cst_inv_qty_temp(
1481: qty_source,
1482: organization_id,
1483: inventory_item_id,
1484: category_id,

Line 1590: INTO cst_inv_qty_temp(

1586: -- costed_flag in ('N','E'), we check for costed_flag is NULL and
1587: -- transaction_date > p_valuation_date
1588: l_stmt_num := 50;
1589: INSERT
1590: INTO cst_inv_qty_temp(
1591: qty_source,
1592: organization_id,
1593: inventory_item_id,
1594: category_id,

Line 1690: INTO cst_inv_qty_temp(

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,
1693: inventory_item_id,
1694: category_id,

Line 1795: INTO cst_inv_qty_temp(

1791: -- MMT.transfer_organization_id = p_organization_id, we check for
1792: -- MMT.organization_id = p_organization_id
1793: l_stmt_num := 70;
1794: INSERT
1795: INTO cst_inv_qty_temp(
1796: qty_source,
1797: organization_id,
1798: inventory_item_id,
1799: category_id,

Line 1892: INTO cst_inv_qty_temp(

1888: -- MMT.organization_id = p_organization_id, we check for
1889: -- MMT.organization_id = p_organization_id
1890: l_stmt_num := 80;
1891: INSERT
1892: INTO cst_inv_qty_temp(
1893: qty_source,
1894: organization_id,
1895: inventory_item_id,
1896: category_id,

Line 1991: INTO cst_inv_qty_temp(

1987: IF p_valuation_date IS NOT NULL
1988: THEN
1989: l_stmt_num := 90;
1990: INSERT
1991: INTO cst_inv_qty_temp(
1992: qty_source,
1993: organization_id,
1994: inventory_item_id,
1995: category_id,

Line 2089: INTO cst_inv_qty_temp(

2085: -- costed_flag in ('N','E'), we check for costed_flag is NULL and
2086: -- transaction_date > p_valuation_date
2087: l_stmt_num := 100;
2088: INSERT
2089: INTO cst_inv_qty_temp(
2090: qty_source,
2091: organization_id,
2092: inventory_item_id,
2093: category_id,

Line 2207: INTO cst_inv_qty_temp(

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,
2210: inventory_item_id,
2211: category_id,

Line 2306: INTO cst_inv_qty_temp(

2302: IF NVL(p_unvalued_txns,-1) <> 1 THEN
2303: IF l_uncosted_txn_count > 0 THEN --BUG#6109468-FPBUG5606455
2304: l_stmt_num := 120;
2305: INSERT
2306: INTO cst_inv_qty_temp(
2307: qty_source,
2308: organization_id,
2309: inventory_item_id,
2310: category_id,

Line 2392: INTO cst_inv_qty_temp(

2388: -- Calculate uncosted intransit receipt quantities coming into this
2389: -- organization
2390: l_stmt_num := 130;
2391: INSERT
2392: INTO cst_inv_qty_temp(
2393: qty_source,
2394: organization_id,
2395: inventory_item_id,
2396: category_id,

Line 2485: INTO cst_inv_qty_temp(

2481: -- costed_flag in ('N','E'), we check for costed_flag is NULL and
2482: -- transaction_date > p_valuation_date
2483: l_stmt_num := 140;
2484: INSERT
2485: INTO cst_inv_qty_temp(
2486: qty_source,
2487: organization_id,
2488: inventory_item_id,
2489: category_id,

Line 2591: INTO cst_inv_qty_temp(

2587: -- costed_flag in ('N','E'), we check for costed_flag is NULL and
2588: -- transaction_date > p_valuation_date
2589: l_stmt_num := 150;
2590: INSERT
2591: INTO cst_inv_qty_temp(
2592: qty_source,
2593: organization_id,
2594: inventory_item_id,
2595: category_id,

Line 2690: INTO cst_inv_qty_temp(

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,
2693: inventory_item_id,
2694: category_id,

Line 2790: INTO cst_inv_qty_temp(

2786: -- MMT.organization_id = p_organization_id
2787: IF l_uncosted_txn_count >0 THEN --BUG6109468-FPBUG5606455
2788: l_stmt_num := 170;
2789: INSERT
2790: INTO cst_inv_qty_temp(
2791: qty_source,
2792: organization_id,
2793: inventory_item_id,
2794: category_id,

Line 2879: INTO cst_inv_qty_temp(

2875: -- MMT.organization_id = p_organization_id, we check for
2876: -- MMT.organization_id = p_organization_id
2877: l_stmt_num := 180;
2878: INSERT
2879: INTO cst_inv_qty_temp(
2880: qty_source,
2881: organization_id,
2882: inventory_item_id,
2883: category_id,

Line 2974: INTO cst_inv_qty_temp(

2970: IF p_valuation_date IS NOT NULL
2971: THEN
2972: l_stmt_num := 190;
2973: INSERT
2974: INTO cst_inv_qty_temp(
2975: qty_source,
2976: organization_id,
2977: inventory_item_id,
2978: category_id,

Line 3068: INTO cst_inv_qty_temp(

3064: -- costed_flag in ('N','E'), we check for costed_flag is NULL and
3065: -- transaction_date > p_valuation_date
3066: l_stmt_num := 200;
3067: INSERT
3068: INTO cst_inv_qty_temp(
3069: qty_source,
3070: organization_id,
3071: inventory_item_id,
3072: category_id,

Line 3247: INTO cst_inv_qty_temp(

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,
3250: inventory_item_id,
3251: category_id,

Line 3331: INTO cst_inv_qty_temp(

3327:
3328: IF (p_valuation_date is not null) THEN
3329: l_stmt_num := 30;
3330: INSERT
3331: INTO cst_inv_qty_temp(
3332: qty_source,
3333: organization_id,
3334: inventory_item_id,
3335: category_id,

Line 3522: FROM cst_inv_qty_temp CIQT,

3518: SELECT DISTINCT
3519: CIQT.organization_id,
3520: CIQT.inventory_item_id,
3521: CIQT.cost_type_id
3522: FROM cst_inv_qty_temp CIQT,
3523: mtl_parameters MP
3524: WHERE CIQT.organization_id = p_organization_id
3525: AND MP.organization_id = p_organization_id
3526: AND MP.primary_cost_method = 1

Line 3546: FROM cst_inv_qty_temp CIQT

3542: SELECT DISTINCT
3543: CIQT.organization_id,
3544: CIQT.inventory_item_id,
3545: CIQT.rcv_transaction_id
3546: FROM cst_inv_qty_temp CIQT
3547: WHERE CIQT.qty_source in (9,10);
3548:
3549: PROCEDURE use_transactional_cost(p_organization_id IN NUMBER,
3550: p_valuation_date IN DATE,

Line 3888: FROM cst_inv_qty_temp

3884: organization_id,
3885: inventory_item_id,
3886: cost_group_id,
3887: cost_type_id
3888: FROM cst_inv_qty_temp
3889: WHERE qty_source NOT IN (1,2,9,10)
3890: ) CIQT,
3891: cst_quantity_layers CQL,
3892: cst_item_costs CIC,

Line 4294: FROM cst_inv_qty_temp

4290: organization_id,
4291: inventory_item_id,
4292: cost_group_id,
4293: cost_type_id
4294: FROM cst_inv_qty_temp
4295: WHERE qty_source NOT IN (1,2,9,10)
4296: ) CIQT,
4297: cst_item_costs CIC,
4298: mtl_parameters MP

Line 4338: FROM cst_inv_qty_temp CIQT,

4334: 0,
4335: 0,
4336: 0,
4337: 0
4338: FROM cst_inv_qty_temp CIQT,
4339: mtl_parameters MP,
4340: cst_item_costs CIC
4341: WHERE MP.organization_id = CIQT.organization_id
4342: AND MP.primary_cost_method <> 1

Line 4441: FROM cst_inv_qty_temp CIQT1

4437: DISTINCT
4438: CIQT1.organization_id,
4439: CIQT1.inventory_item_id,
4440: CIQT1.cost_group_id
4441: FROM cst_inv_qty_temp CIQT1
4442: WHERE CIQT1.qty_source NOT IN (1,2,9,10)
4443: -- PRIOR SUMMARY, CURRENT SUMMARY, RECEIVING, PAST RECEIVING
4444: AND NOT EXISTS ( SELECT 1
4445: FROM cst_inv_cost_temp CICT

Line 4630: FROM cst_inv_qty_temp CIQT,

4626: CIQT.organization_id,
4627: CIQT.inventory_item_id,
4628: CIQT.cost_group_id,
4629: MP.primary_cost_method
4630: FROM cst_inv_qty_temp CIQT,
4631: mtl_parameters MP
4632: WHERE MP.organization_id = CIQT.organization_id
4633: AND MP.primary_cost_method <> 1
4634: AND CIQT.qty_source NOT IN (1,2,9,10)