APPS.GMI_INVENTORY_CLOSE_CONC dependencies on IC_ITEM_MST

Line 414: /* Bug 3684980 - changed to ic_item_mst_b for perf. */

410: WHERE flow_type = 0
411: AND delete_mark = 0
412: AND reason_code = v_reason_code;
413:
414: /* Bug 3684980 - changed to ic_item_mst_b for perf. */
415: /* Also only populated ic_perd_bal with non-zero rows */
416: Cursor get_loct_onhand is
417: SELECT v.item_id ,v.lot_id ,
418: whse_code ,location ,ROUND(loct_onhand,9) onhand,

Line 421: from ic_loct_inv v, ic_item_mst_b m

417: SELECT v.item_id ,v.lot_id ,
418: whse_code ,location ,ROUND(loct_onhand,9) onhand,
419: ROUND(loct_onhand2,9) onhand2,
420: v.lot_status,v.qchold_res_code
421: from ic_loct_inv v, ic_item_mst_b m
422: WHERE whse_code = pwhse_code
423: AND noninv_ind = 0
424: AND v.item_id = m.item_id
425: AND v.delete_mark = 0

Line 454: /* Bug 3684980 - changed to union all and ic_item_mst_b for perf. */

450: items.
451: *********************************************/
452:
453:
454: /* Bug 3684980 - changed to union all and ic_item_mst_b for perf. */
455: CURSOR get_trans IS
456: SELECT p.item_id, lot_id, whse_code,
457: location, doc_type, line_type,
458: reason_code, trans_date, trans_id,

Line 460: FROM ic_tran_pnd p, ic_item_mst_b m

456: SELECT p.item_id, lot_id, whse_code,
457: location, doc_type, line_type,
458: reason_code, trans_date, trans_id,
459: trans_qty, trans_qty2
460: FROM ic_tran_pnd p, ic_item_mst_b m
461: WHERE whse_code = uwhse_code
462: AND trans_date >= pprd_start_date
463: AND p.creation_date <= l_log_end_date
464: AND trans_qty <> 0

Line 474: FROM ic_tran_cmp c, ic_item_mst_b m

470: SELECT c.item_id, lot_id, whse_code,
471: location, doc_type, line_type,
472: reason_code, trans_date, trans_id,
473: trans_qty, trans_qty2
474: FROM ic_tran_cmp c, ic_item_mst_b m
475: WHERE whse_code = uwhse_code
476: AND trans_date >= pprd_start_date
477: AND c.creation_date <= l_log_end_date
478: AND trans_qty <> 0