[Home] [Help]
677: -- Bug 9301755 - Introduce cursor to get line_type and variables.
678: -- Bug 9770408 - Fetch the divisible flag also.
679: CURSOR Cur_get_material_line_type (v_transaction_id NUMBER) IS
680: SELECT d.line_type, NVL( lot_divisible_flag, 'Y')
681: FROM mtl_material_transactions t, gme_material_details d, mtl_system_items_b i
682: WHERE t.transaction_source_type_id = 5
683: AND t.transaction_id = v_transaction_id
684: AND d.batch_id = t.transaction_source_id
685: AND d.material_detail_id = t.trx_source_line_id
883:
884: -- Bug 8639523 - Introduce cursor to get line_type and variables.
885: CURSOR Cur_get_material_line_type (v_transaction_id NUMBER) IS
886: SELECT d.line_type, NVL( lot_divisible_flag, 'Y')
887: FROM mtl_material_transactions t, gme_material_details d, mtl_system_items_b i
888: WHERE t.transaction_source_type_id = 5
889: AND t.transaction_id = v_transaction_id
890: AND d.batch_id = t.transaction_source_id
891: AND d.material_detail_id = t.trx_source_line_id
1605:
1606: -- Bug 14065291
1607: CURSOR Cur_get_material_info (v_organization_id NUMBER, v_inventory_item_id NUMBER) IS
1608: SELECT i.primary_uom_code, k.concatenated_segments, i.secondary_uom_code
1609: FROM mtl_system_items_b i, mtl_system_items_kfv k
1610: WHERE v_inventory_item_id = i.inventory_item_id
1611: AND v_organization_id = i.organization_id
1612: AND v_inventory_item_id = k.inventory_item_id
1613: AND v_organization_id = k.organization_id;
3386:
3387: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)
3388: IS
3389: SELECT *
3390: FROM mtl_system_items_b
3391: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
3392: CURSOR Cur_associated_step(v_matl_dtl_id NUMBER)
3393: IS
3394: SELECT step_status
3406: l_mmti_rec mtl_transactions_interface%ROWTYPE;
3407: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
3408: l_mat_dtl_rec gme_material_details%ROWTYPE;
3409: l_batch_hdr_rec gme_batch_header%ROWTYPE;
3410: l_item_rec mtl_system_items_b%ROWTYPE;
3411: l_available_qty NUMBER;
3412: l_step_status NUMBER;
3413: l_rel_type NUMBER;
3414: l_return_status VARCHAR2(1);
3542: IF cur_get_item_rec%NOTFOUND THEN
3543: CLOSE cur_get_item_rec;
3544: gme_common_pvt.log_message ('PM_INVALID_ITEM');
3545: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3546: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
3547: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (l_mmti_rec.inventory_item_id));
3548: gme_debug.put_line('organization_id = '|| TO_CHAR (l_mmti_rec.organization_id));
3549: END IF;
3550: RAISE item_not_found;
4743: FROM
4744: --mtl_material_transactions mmt,
4745: --mtl_transaction_lot_numbers mtln,
4746: mtl_material_transactions mmt, /* Removed mtln for Bug 8347011 base bug 8219507 */
4747: mtl_system_items_b msi,
4748: gme_material_details md,
4749: gme_transaction_pairs gtp
4750: WHERE
4751: mmt.transaction_set_id = gme_common_pvt.g_transaction_header_id
5791: p_mode IN VARCHAR2,
5792: x_return_status OUT NOCOPY VARCHAR2) IS
5793: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER) IS
5794: SELECT *
5795: FROM mtl_system_items_b
5796: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
5797: CURSOR Cur_associated_step(v_matl_dtl_id NUMBER) IS
5798: SELECT step_status
5799: FROM gme_batch_steps s, gme_batch_step_items i
5800: WHERE s.batchstep_id = i.batchstep_id
5801: AND i.material_detail_id = v_matl_dtl_id;
5802: l_mat_dtl_rec gme_material_details%ROWTYPE;
5803: l_batch_hdr_rec gme_batch_header%ROWTYPE;
5804: l_item_rec mtl_system_items_b%ROWTYPE;
5805: l_available_qty NUMBER;
5806: l_step_status NUMBER;
5807: l_rel_type NUMBER;
5808: l_return_status VARCHAR2(1);
5883: IF cur_get_item_rec%NOTFOUND THEN
5884: CLOSE cur_get_item_rec;
5885: gme_common_pvt.log_message ('PM_INVALID_ITEM');
5886: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
5887: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
5888: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (p_mmti_rec.inventory_item_id));
5889: gme_debug.put_line('organization_id = '|| TO_CHAR (p_mmti_rec.organization_id));
5890: END IF;
5891: RAISE item_not_found;