APPS.GME_TRANSACTIONS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 2540: FROM mtl_system_items_b

2536:
2537: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)
2538: IS
2539: SELECT *
2540: FROM mtl_system_items_b
2541: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
2542: CURSOR Cur_associated_step(v_matl_dtl_id NUMBER)
2543: IS
2544: SELECT step_status

Line 2560: l_item_rec mtl_system_items_b%ROWTYPE;

2556: l_mmti_rec mtl_transactions_interface%ROWTYPE;
2557: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
2558: l_mat_dtl_rec gme_material_details%ROWTYPE;
2559: l_batch_hdr_rec gme_batch_header%ROWTYPE;
2560: l_item_rec mtl_system_items_b%ROWTYPE;
2561: l_available_qty NUMBER;
2562: l_step_status NUMBER;
2563: l_rel_type NUMBER;
2564: l_return_status VARCHAR2(1);

Line 2693: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');

2689: IF cur_get_item_rec%NOTFOUND THEN
2690: CLOSE cur_get_item_rec;
2691: gme_common_pvt.log_message ('PM_INVALID_ITEM');
2692: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2693: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
2694: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (l_mmti_rec.inventory_item_id));
2695: gme_debug.put_line('organization_id = '|| TO_CHAR (l_mmti_rec.organization_id));
2696: END IF;
2697: RAISE item_not_found;

Line 3759: mtl_system_items_b msi,

3755: , mmt.last_update_login
3756: FROM
3757: mtl_material_transactions mmt,
3758: mtl_transaction_lot_numbers mtln,
3759: mtl_system_items_b msi,
3760: gme_material_details md,
3761: gme_transaction_pairs gtp
3762: WHERE
3763: mmt.transaction_set_id = gme_common_pvt.g_transaction_header_id

Line 4749: FROM mtl_system_items_b

4745: p_mode IN VARCHAR2,
4746: x_return_status OUT NOCOPY VARCHAR2) IS
4747: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER) IS
4748: SELECT *
4749: FROM mtl_system_items_b
4750: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
4751: CURSOR Cur_associated_step(v_matl_dtl_id NUMBER) IS
4752: SELECT step_status
4753: FROM gme_batch_steps s, gme_batch_step_items i

Line 4758: l_item_rec mtl_system_items_b%ROWTYPE;

4754: WHERE s.batchstep_id = i.batchstep_id
4755: AND i.material_detail_id = v_matl_dtl_id;
4756: l_mat_dtl_rec gme_material_details%ROWTYPE;
4757: l_batch_hdr_rec gme_batch_header%ROWTYPE;
4758: l_item_rec mtl_system_items_b%ROWTYPE;
4759: l_available_qty NUMBER;
4760: l_step_status NUMBER;
4761: l_rel_type NUMBER;
4762: l_return_status VARCHAR2(1);

Line 4839: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');

4835: IF cur_get_item_rec%NOTFOUND THEN
4836: CLOSE cur_get_item_rec;
4837: gme_common_pvt.log_message ('PM_INVALID_ITEM');
4838: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4839: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
4840: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (p_mmti_rec.inventory_item_id));
4841: gme_debug.put_line('organization_id = '|| TO_CHAR (p_mmti_rec.organization_id));
4842: END IF;
4843: RAISE item_not_found;