DBA Data[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on CST_INV_QTY_TEMP

Line 718: INTO cst_inv_qty_temp(

714:
715: -- Calculate Current Onhand Quantity
716: l_stmt_num := 10;
717: INSERT
718: INTO cst_inv_qty_temp(
719: organization_id,
720: cost_group_id,
721: subinventory_code,
722: inventory_item_id,

Line 769: INTO cst_inv_qty_temp(

765: l_stmt_num := 20;
766: IF NVL(p_unvalued_txns,-1) <> 1
767: THEN
768: INSERT
769: INTO cst_inv_qty_temp(
770: organization_id,
771: cost_group_id,
772: subinventory_code,
773: inventory_item_id,

Line 839: INTO cst_inv_qty_temp

835: l_stmt_num := 30;
836: IF p_valuation_date IS NOT NULL
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 939: INTO cst_inv_qty_temp(

935: IF p_zero_qty = 1
936: THEN
937: l_stmt_num := 40;
938: INSERT
939: INTO cst_inv_qty_temp(
940: organization_id,
941: inventory_item_id,
942: rollback_qty,
943: qty_source,

Line 965: FROM cst_inv_qty_temp

961: SELECT DISTINCT
962: inventory_item_id,
963: category_id,
964: cost_type_id
965: FROM cst_inv_qty_temp
966: WHERE organization_id = p_organization_id
967: ) TEMP,
968: mtl_parameters MP
969: WHERE MP.organization_id = p_organization_id;

Line 1108: INTO cst_inv_qty_temp(

1104: THEN
1105: -- Calculate current intransit quantity coming into this organization
1106: l_stmt_num := 10;
1107: INSERT
1108: INTO cst_inv_qty_temp(
1109: qty_source,
1110: organization_id,
1111: inventory_item_id,
1112: category_id,

Line 1211: INTO cst_inv_qty_temp(

1207: IF l_uncosted_txn_count > 0 THEN --BUG6109468-FP5606455
1208:
1209: l_stmt_num := 20;
1210: INSERT
1211: INTO cst_inv_qty_temp(
1212: qty_source,
1213: organization_id,
1214: inventory_item_id,
1215: category_id,

Line 1307: INTO cst_inv_qty_temp(

1303: -- Calculate uncosted intransit receipt quantities coming into this
1304: -- organization
1305: l_stmt_num := 30;
1306: INSERT
1307: INTO cst_inv_qty_temp(
1308: qty_source,
1309: organization_id,
1310: inventory_item_id,
1311: category_id,

Line 1408: INTO cst_inv_qty_temp(

1404: -- costed_flag in ('N','E'), we check for costed_flag is NULL and
1405: -- transaction_date > p_valuation_date
1406: l_stmt_num := 40;
1407: INSERT
1408: INTO cst_inv_qty_temp(
1409: qty_source,
1410: organization_id,
1411: inventory_item_id,
1412: category_id,

Line 1509: INTO cst_inv_qty_temp(

1505: -- costed_flag in ('N','E'), we check for costed_flag is NULL and
1506: -- transaction_date > p_valuation_date
1507: l_stmt_num := 50;
1508: INSERT
1509: INTO cst_inv_qty_temp(
1510: qty_source,
1511: organization_id,
1512: inventory_item_id,
1513: category_id,

Line 1610: INTO cst_inv_qty_temp(

1606: -- p_organization_id, we check for MS.from_organization_id =
1607: -- p_organization_id
1608: l_stmt_num := 60;
1609: INSERT
1610: INTO cst_inv_qty_temp(
1611: qty_source,
1612: organization_id,
1613: inventory_item_id,
1614: category_id,

Line 1714: INTO cst_inv_qty_temp(

1710: -- MMT.transfer_organization_id = p_organization_id, we check for
1711: -- MMT.organization_id = p_organization_id
1712: l_stmt_num := 70;
1713: INSERT
1714: INTO cst_inv_qty_temp(
1715: qty_source,
1716: organization_id,
1717: inventory_item_id,
1718: category_id,

Line 1814: INTO cst_inv_qty_temp(

1810: -- MMT.organization_id = p_organization_id, we check for
1811: -- MMT.organization_id = p_organization_id
1812: l_stmt_num := 80;
1813: INSERT
1814: INTO cst_inv_qty_temp(
1815: qty_source,
1816: organization_id,
1817: inventory_item_id,
1818: category_id,

Line 1915: INTO cst_inv_qty_temp(

1911: IF p_valuation_date IS NOT NULL
1912: THEN
1913: l_stmt_num := 90;
1914: INSERT
1915: INTO cst_inv_qty_temp(
1916: qty_source,
1917: organization_id,
1918: inventory_item_id,
1919: category_id,

Line 2016: INTO cst_inv_qty_temp(

2012: -- costed_flag in ('N','E'), we check for costed_flag is NULL and
2013: -- transaction_date > p_valuation_date
2014: l_stmt_num := 100;
2015: INSERT
2016: INTO cst_inv_qty_temp(
2017: qty_source,
2018: organization_id,
2019: inventory_item_id,
2020: category_id,

Line 2122: INTO cst_inv_qty_temp(

2118: THEN
2119: -- Calculate current intransit quantity coming into this organization
2120: l_stmt_num := 110;
2121: INSERT
2122: INTO cst_inv_qty_temp(
2123: qty_source,
2124: organization_id,
2125: inventory_item_id,
2126: category_id,

Line 2220: INTO cst_inv_qty_temp(

2216: IF NVL(p_unvalued_txns,-1) <> 1 THEN
2217: IF l_uncosted_txn_count > 0 THEN --BUG#6109468-FPBUG5606455
2218: l_stmt_num := 120;
2219: INSERT
2220: INTO cst_inv_qty_temp(
2221: qty_source,
2222: organization_id,
2223: inventory_item_id,
2224: category_id,

Line 2308: INTO cst_inv_qty_temp(

2304: -- Calculate uncosted intransit receipt quantities coming into this
2305: -- organization
2306: l_stmt_num := 130;
2307: INSERT
2308: INTO cst_inv_qty_temp(
2309: qty_source,
2310: organization_id,
2311: inventory_item_id,
2312: category_id,

Line 2404: INTO cst_inv_qty_temp(

2400: -- costed_flag in ('N','E'), we check for costed_flag is NULL and
2401: -- transaction_date > p_valuation_date
2402: l_stmt_num := 140;
2403: INSERT
2404: INTO cst_inv_qty_temp(
2405: qty_source,
2406: organization_id,
2407: inventory_item_id,
2408: category_id,

Line 2501: INTO cst_inv_qty_temp(

2497: -- costed_flag in ('N','E'), we check for costed_flag is NULL and
2498: -- transaction_date > p_valuation_date
2499: l_stmt_num := 150;
2500: INSERT
2501: INTO cst_inv_qty_temp(
2502: qty_source,
2503: organization_id,
2504: inventory_item_id,
2505: category_id,

Line 2601: INTO cst_inv_qty_temp(

2597: -- p_organization_id, we check for MS.from_organization_id =
2598: -- p_organization_id
2599: l_stmt_num := 60;
2600: INSERT
2601: INTO cst_inv_qty_temp(
2602: qty_source,
2603: organization_id,
2604: inventory_item_id,
2605: category_id,

Line 2700: INTO cst_inv_qty_temp(

2696: -- MMT.organization_id = p_organization_id
2697: IF l_uncosted_txn_count >0 THEN --BUG6109468-FPBUG5606455
2698: l_stmt_num := 70;
2699: INSERT
2700: INTO cst_inv_qty_temp(
2701: qty_source,
2702: organization_id,
2703: inventory_item_id,
2704: category_id,

Line 2792: INTO cst_inv_qty_temp(

2788: -- MMT.organization_id = p_organization_id, we check for
2789: -- MMT.organization_id = p_organization_id
2790: l_stmt_num := 80;
2791: INSERT
2792: INTO cst_inv_qty_temp(
2793: qty_source,
2794: organization_id,
2795: inventory_item_id,
2796: category_id,

Line 2888: INTO cst_inv_qty_temp(

2884: IF p_valuation_date IS NOT NULL
2885: THEN
2886: l_stmt_num := 90;
2887: INSERT
2888: INTO cst_inv_qty_temp(
2889: qty_source,
2890: organization_id,
2891: inventory_item_id,
2892: category_id,

Line 2985: INTO cst_inv_qty_temp(

2981: -- costed_flag in ('N','E'), we check for costed_flag is NULL and
2982: -- transaction_date > p_valuation_date
2983: l_stmt_num := 200;
2984: INSERT
2985: INTO cst_inv_qty_temp(
2986: qty_source,
2987: organization_id,
2988: inventory_item_id,
2989: category_id,

Line 3152: INTO cst_inv_qty_temp(

3148: -- the parent RECEIVE or MATCH with the exception of cases in which
3149: -- there was an Accept/Reject/Transfer transaction.
3150: l_stmt_num := 10;
3151: INSERT
3152: INTO cst_inv_qty_temp(
3153: qty_source,
3154: organization_id,
3155: inventory_item_id,
3156: category_id,

Line 3235: INTO cst_inv_qty_temp(

3231:
3232: IF (p_valuation_date is not null) THEN
3233: l_stmt_num := 30;
3234: INSERT
3235: INTO cst_inv_qty_temp(
3236: qty_source,
3237: organization_id,
3238: inventory_item_id,
3239: category_id,

Line 3422: FROM cst_inv_qty_temp CIQT,

3418: SELECT DISTINCT
3419: CIQT.organization_id,
3420: CIQT.inventory_item_id,
3421: CIQT.cost_type_id
3422: FROM cst_inv_qty_temp CIQT,
3423: mtl_parameters MP
3424: WHERE CIQT.organization_id = p_organization_id
3425: AND MP.organization_id = p_organization_id
3426: AND MP.primary_cost_method = 1

Line 3446: FROM cst_inv_qty_temp CIQT

3442: SELECT DISTINCT
3443: CIQT.organization_id,
3444: CIQT.inventory_item_id,
3445: CIQT.rcv_transaction_id
3446: FROM cst_inv_qty_temp CIQT
3447: WHERE CIQT.qty_source in (9,10);
3448:
3449:
3450: --

Line 3709: FROM cst_inv_qty_temp

3705: organization_id,
3706: inventory_item_id,
3707: cost_group_id,
3708: cost_type_id
3709: FROM cst_inv_qty_temp
3710: WHERE qty_source NOT IN (1,2,9,10)
3711: ) CIQT,
3712: cst_quantity_layers CQL,
3713: cst_item_costs CIC,

Line 4182: FROM cst_inv_qty_temp CIQT,

4178: 0,
4179: 0,
4180: 0,
4181: 0
4182: FROM cst_inv_qty_temp CIQT,
4183: mtl_parameters MP,
4184: cst_item_costs CIC
4185: WHERE MP.organization_id = CIQT.organization_id
4186: AND MP.primary_cost_method <> 1

Line 4255: FROM cst_inv_qty_temp CIQT,

4251: CIQT.organization_id,
4252: CIQT.inventory_item_id,
4253: CIQT.cost_group_id,
4254: MP.primary_cost_method
4255: FROM cst_inv_qty_temp CIQT,
4256: mtl_parameters MP
4257: WHERE MP.organization_id = CIQT.organization_id
4258: AND MP.primary_cost_method <> 1
4259: AND CIQT.qty_source NOT IN (1,2,9,10)

Line 4606: FROM cst_inv_qty_temp CIQT,

4602: CIQT.organization_id,
4603: CIQT.inventory_item_id,
4604: CIQT.cost_group_id,
4605: MP.primary_cost_method
4606: FROM cst_inv_qty_temp CIQT,
4607: mtl_parameters MP
4608: WHERE MP.organization_id = CIQT.organization_id
4609: AND MP.primary_cost_method <> 1
4610: AND CIQT.qty_source NOT IN (1,2,9,10)