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.GMI_RESERVATION_PVT dependencies on IC_TRAN_PND

Line 94: | Query reservations included in table IC_TRAN_PND. |

90: | TYPE |
91: | Global |
92: | |
93: | USAGE |
94: | Query reservations included in table IC_TRAN_PND. |
95: | If found, fetch data into a table of rec_type. |
96: | |
97: | DESCRIPTION |
98: | Query reservations included in table IC_TRAN_PND. |

Line 98: | Query reservations included in table IC_TRAN_PND. |

94: | Query reservations included in table IC_TRAN_PND. |
95: | If found, fetch data into a table of rec_type. |
96: | |
97: | DESCRIPTION |
98: | Query reservations included in table IC_TRAN_PND. |
99: | If found, fetch data into a table of rec_type. |
100: | |
101: | PARAMETERS |
102: | x_return_status OUT VARCHAR2 - Return Status |

Line 230: FROM ic_tran_pnd

226: , NULL /* user id */
227: , NULL /* create_lot_index */
228: , NULL /* non_inv field */
229: , line_detail_id
230: FROM ic_tran_pnd
231: WHERE doc_type ='OMSO'
232: AND delete_mark = 0
233: AND completed_ind = 0
234: AND line_id = p_query_input.demand_source_line_id

Line 329: /* Convert reserved quantity (in ic_tran_pnd, so OPM) into the reservation_UOM of the SO. */

325: END IF;
326: END IF;
327:
328: /* ============================================================================================= */
329: /* Convert reserved quantity (in ic_tran_pnd, so OPM) into the reservation_UOM of the SO. */
330: /* =============================================================================================*/
331: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT q OPM_order_um='||l_OPM_order_um||', item_um='||l_ic_item_mst_rec.item_um||'.');
332: IF (l_OPM_order_um <> l_ic_item_mst_rec.item_um)
333: THEN

Line 512: FROM ic_tran_pnd

508: where whse_code = l_allocation_rec.whse_code;
509: -- end fabdi
510: CURSOR check_detailed_allocations IS
511: SELECT SUM(ABS(trans_qty))
512: FROM ic_tran_pnd
513: WHERE line_id = p_rsv_rec.demand_source_line_id
514: AND doc_type = 'OMSO'
515: AND staged_ind = 0
516: AND completed_ind = 0

Line 685: x_ic_tran_pnd_index => l_default_lot_index

681:
682:
683: /* Retrieve the default lot in the transaction*/
684: GMI_Reservation_Util.Get_Default_Lot(
685: x_ic_tran_pnd_index => l_default_lot_index
686: , x_return_status => x_return_status
687: , x_msg_count => x_msg_count
688: , x_msg_data => x_msg_data);
689:

Line 983: l_temp_tran_row IC_TRAN_PND%ROWTYPE;

979: l_validation_level VARCHAR2(4) := fnd_api.g_valid_level_full;
980: l_api_name CONSTANT VARCHAR2(30) := 'Update_Reservation';
981: l_api_version CONSTANT VARCHAR2(10) := '1.0';
982:
983: l_temp_tran_row IC_TRAN_PND%ROWTYPE;
984: l_ic_tran_row IC_TRAN_PND%ROWTYPE;
985:
986: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
987: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

Line 984: l_ic_tran_row IC_TRAN_PND%ROWTYPE;

980: l_api_name CONSTANT VARCHAR2(30) := 'Update_Reservation';
981: l_api_version CONSTANT VARCHAR2(10) := '1.0';
982:
983: l_temp_tran_row IC_TRAN_PND%ROWTYPE;
984: l_ic_tran_row IC_TRAN_PND%ROWTYPE;
985:
986: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
987: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
988: l_default_lot_index BINARY_INTEGER;

Line 1073: x_ic_tran_pnd_index => l_default_lot_index

1069:
1070: /* Retrieve the default lot transaction we'll need it later */
1071: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u:: we have rows now calling Get_Default_Lot.');
1072: GMI_Reservation_Util.Get_Default_Lot(
1073: x_ic_tran_pnd_index => l_default_lot_index
1074: , x_return_status => x_return_status
1075: , x_msg_count => x_msg_count
1076: , x_msg_data => x_msg_data);
1077:

Line 1103: ,x_ic_tran_pnd_index => l_original_tran_index

1099: IF (l_default_tran_rec.trans_id <> p_original_rsv_rec.reservation_id)
1100: THEN
1101: GMI_Reservation_Util.Get_Allocation(
1102: p_trans_id => p_original_rsv_rec.reservation_id
1103: ,x_ic_tran_pnd_index => l_original_tran_index
1104: ,x_return_status => x_return_status
1105: ,x_msg_count => x_msg_count
1106: ,x_msg_data => x_msg_data);
1107:

Line 1185: /* Always the same as the transaction in IC_TRAN_PND*/

1181: END IF;
1182:
1183: /* Okay Lets Check For Secondary Quantities. We should Store*/
1184: /* The Secondary Qty in p_to_rsv_rec. Attribute2 the UOM is*/
1185: /* Always the same as the transaction in IC_TRAN_PND*/
1186: /* Therefore there will be no conversions so Store the Value.*/
1187:
1188: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: attribute2'||p_to_rsv_rec.attribute2);
1189: IF p_to_rsv_rec.attribute2 = FND_API.G_MISS_CHAR or p_to_rsv_rec.attribute2 is null

Line 1199: /* next we need to convert it to the ic_tran_pnd uom which is the item primary uom*/

1195: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: qty2'||l_new_rsv_to_item_um_qty2);
1196:
1197: /* Compare reservation qtys if new qty is greater than old qty then add difference to the default*/
1198: /* l_orig_conv_to_new_rsv_qty is the same whether the uom changed or not, it is the new reservation quantity*/
1199: /* next we need to convert it to the ic_tran_pnd uom which is the item primary uom*/
1200: /* ---------------------------------------------------------------------------------*/
1201: /* If the new qty is greater than the old qty add the change to the default row qty*/
1202: /* ---------------------------------------------------------------------------------*/
1203: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: l_new_rsv_to_item_um_qty is ' || l_new_rsv_to_item_um_qty);

Line 1477: l_temp_tran_row IC_TRAN_PND%ROWTYPE;

1473: l_commit VARCHAR2(5) := fnd_api.g_false;
1474: l_validation_level VARCHAR2(4) := fnd_api.g_valid_level_full;
1475: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1476: l_tran_to_delete_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1477: l_temp_tran_row IC_TRAN_PND%ROWTYPE;
1478: l_default_lot_index BINARY_INTEGER;
1479: l_allocated_lot_index BINARY_INTEGER;
1480: l_default_lot_quantity1 NUMBER;
1481: l_default_lot_quantity2 NUMBER;

Line 1546: x_ic_tran_pnd_index => l_default_lot_index

1542: RAISE FND_API.G_EXC_ERROR;
1543: END IF;
1544:
1545: GMI_Reservation_Util.Get_Default_Lot(
1546: x_ic_tran_pnd_index => l_default_lot_index
1547: , x_return_status => x_return_status
1548: , x_msg_count => x_msg_count
1549: , x_msg_data => x_msg_data);
1550:

Line 1571: , x_ic_tran_pnd_index => l_allocated_lot_index

1567:
1568: /* Get the Allocation*/
1569: GMI_Reservation_Util.Get_Allocation(
1570: p_trans_id => p_rsv_rec.reservation_id
1571: , x_ic_tran_pnd_index => l_allocated_lot_index
1572: , x_return_status => x_return_status
1573: , x_msg_count => x_msg_count
1574: , x_msg_data => x_msg_data);
1575:

Line 1964: FROM ic_tran_pnd

1960: CURSOR reserved_quantity_real(p_item_id NUMBER
1961: ,l_whse_code VARCHAR2) is
1962: SELECT ABS(SUM(nvl(trans_qty,0))),
1963: ABS(SUM(nvl(trans_qty2,0)))
1964: FROM ic_tran_pnd
1965: WHERE item_id = p_item_id
1966: AND whse_code = l_whse_code
1967: AND (lot_id <> 0 OR location <> GMI_RESERVATION_UTIL.G_DEFAULT_LOCT)
1968: AND completed_ind = 0

Line 1985: FROM ic_tran_pnd

1981: -- Get the allocated qty for this delivery detail line
1982: CURSOR Get_trans_for_del IS
1983: SELECT ABS(SUM(nvl(trans_qty,0))),
1984: ABS(SUM(nvl(trans_qty2,0)))
1985: FROM ic_tran_pnd
1986: WHERE line_id = p_demand_source_line_id
1987: AND line_detail_id = p_delivery_detail_id
1988: AND doc_type='OMSO'
1989: AND completed_ind = 0

Line 2018: FROM ic_tran_pnd itp

2014: --Bug 3551144
2015: --Get sum of allocated qty against high level reserved qty
2016: CURSOR high_level_res_qty_real(p_item_id NUMBER,l_whse_code VARCHAR2) is
2017: SELECT NVL(ABS(SUM(nvl(trans_qty,0))),0), NVL(ABS(SUM(nvl(trans_qty2,0))),0)
2018: FROM ic_tran_pnd itp
2019: WHERE item_id = p_item_id
2020: AND whse_code = l_whse_code
2021: AND (lot_id <> 0 OR location <> GMI_RESERVATION_UTIL.G_DEFAULT_LOCT)
2022: AND completed_ind = 0

Line 2241: -- Let's get qty reserved from ic_tran_pnd

2237: g_demand_table(l_index).qty2_available := 0;
2238: END IF;
2239: END IF; -- of not l_demand_exists
2240:
2241: -- Let's get qty reserved from ic_tran_pnd
2242: gmi_reservation_util.println('value of p_demand_source_line_id before calling res_qty is '||p_demand_source_line_id);
2243: gmi_reservation_util.println('Value of p_item_id before calling res_q is '||p_item_id);
2244: gmi_reservation_util.println('Value of l_whse_code before calling res_q is '||l_whse_code);
2245:

Line 2503: FROM ic_tran_pnd

2499: p_item_id NUMBER,
2500: l_qc_grade VARCHAR2) is
2501: SELECT SUM(nvl(trans_qty,0)),
2502: SUM(nvl(trans_qty2,0))
2503: FROM ic_tran_pnd
2504: WHERE item_id = p_item_id
2505: -- AND line_id = p_demand_source_line_id
2506: AND whse_code = l_whse_code
2507: AND completed_ind = 0

Line 2517: FROM ic_tran_pnd

2513: CURSOR reserved_quantity_for_atp(l_whse_code VARCHAR2,
2514: p_item_id NUMBER) is
2515: SELECT SUM(nvl(trans_qty,0)),
2516: SUM(nvl(trans_qty2,0))
2517: FROM ic_tran_pnd
2518: WHERE item_id = p_item_id
2519: -- AND line_id = p_demand_source_line_id
2520: AND whse_code = l_whse_code
2521: AND completed_ind = 0

Line 2543: FROM ic_tran_pnd

2539: -- Get the committed sales for this order line
2540: CURSOR Get_trans_for_null_del IS -- this would include the default lot
2541: SELECT SUM(ABS(nvl(trans_qty,0))),
2542: SUM(ABS(nvl(trans_qty2,0)))
2543: FROM ic_tran_pnd
2544: WHERE line_id = p_demand_source_line_id
2545: AND doc_type='OMSO'
2546: AND completed_ind = 0
2547: AND delete_mark = 0;

Line 2594: gmi_reservation_util.Println('total reserved in ic_tran_pnd qty '|| l_qty_reserved_real);

2590: CLOSE reserved_quantity_for_atp;
2591: END IF;
2592: l_qty_reserved_real := nvl(l_qty_reserved_real, 0);
2593: l_qty2_reserved_real := nvl(l_qty2_reserved_real, 0);
2594: gmi_reservation_util.Println('total reserved in ic_tran_pnd qty '|| l_qty_reserved_real);
2595: gmi_reservation_util.Println('total reserved in ic_tran_pnd qty2 '|| l_qty2_reserved_real);
2596:
2597: IF (l_grade_ctl > 0 and l_grade is not null) THEN
2598: --- from ATP window

Line 2595: gmi_reservation_util.Println('total reserved in ic_tran_pnd qty2 '|| l_qty2_reserved_real);

2591: END IF;
2592: l_qty_reserved_real := nvl(l_qty_reserved_real, 0);
2593: l_qty2_reserved_real := nvl(l_qty2_reserved_real, 0);
2594: gmi_reservation_util.Println('total reserved in ic_tran_pnd qty '|| l_qty_reserved_real);
2595: gmi_reservation_util.Println('total reserved in ic_tran_pnd qty2 '|| l_qty2_reserved_real);
2596:
2597: IF (l_grade_ctl > 0 and l_grade is not null) THEN
2598: --- from ATP window
2599: OPEN qty_on_hand_grade(l_whse_code,p_item_id,l_grade);

Line 2630: -- Let's get qty reserved from ic_tran_pnd

2626: l_qty_available := l_onhand_qty1 + l_qty_reserved_real;
2627: l_qty2_available := l_onhand_qty2 + l_qty2_reserved_real;
2628: -- End Bug 2801666
2629:
2630: -- Let's get qty reserved from ic_tran_pnd
2631:
2632: OPEN get_trans_for_null_del;
2633: FETCH get_trans_for_null_del into l_qty_reserved,l_qty2_reserved;
2634: CLOSE get_trans_for_null_del;

Line 2724: FROM ic_tran_pnd

2720: -- Cursor to Get the allocated qty for this deilery
2721: CURSOR Get_trans_for_del IS
2722: SELECT ABS(SUM(nvl(trans_qty,0))),
2723: ABS(SUM(nvl(trans_qty2,0)))
2724: FROM ic_tran_pnd
2725: WHERE line_id = p_demand_source_line_id
2726: AND line_detail_id = p_delivery_detail_id
2727: AND doc_type='OMSO'
2728: AND completed_ind = 0

Line 3005: FROM ic_tran_pnd

3001: CURSOR reserved_quantity_real(l_opm_itm_id NUMBER
3002: ,l_whse_code VARCHAR2 ) is
3003: SELECT ABS(SUM(nvl(trans_qty,0))),
3004: ABS(SUM(nvl(trans_qty2,0)))
3005: FROM ic_tran_pnd
3006: WHERE item_id = l_opm_itm_id
3007: AND whse_code = l_whse_code
3008: AND (lot_id <> 0 OR location <> GMI_RESERVATION_UTIL.G_DEFAULT_LOCT)
3009: AND completed_ind = 0

Line 3037: FROM ic_tran_pnd itp

3033: --Bug 3551144
3034: --Get sum of allocated qty against high level reserved qty
3035: CURSOR high_level_res_qty_real(p_item_id NUMBER,l_whse_code VARCHAR2) is
3036: SELECT NVL(ABS(SUM(nvl(trans_qty,0))),0), NVL(ABS(SUM(nvl(trans_qty2,0))),0)
3037: FROM ic_tran_pnd itp
3038: WHERE item_id = p_item_id
3039: AND whse_code = l_whse_code
3040: AND (lot_id <> 0 OR location <> GMI_RESERVATION_UTIL.G_DEFAULT_LOCT)
3041: AND completed_ind = 0