DBA Data[Home] [Help]

APPS.GME_MOVE_ORDERS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 317: l_mtl_txns_enabled_flag mtl_system_items_kfv.mtl_transactions_enabled_flag%TYPE;

313: l_from_uom VARCHAR2 (3);
314: l_to_uom VARCHAR2 (3);
315: l_item_no VARCHAR2 (2000);
316: l_msg_data VARCHAR2 (2000);
317: l_mtl_txns_enabled_flag mtl_system_items_kfv.mtl_transactions_enabled_flag%TYPE;
318: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
319: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;
320:
321: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;

Line 318: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

314: l_to_uom VARCHAR2 (3);
315: l_item_no VARCHAR2 (2000);
316: l_msg_data VARCHAR2 (2000);
317: l_mtl_txns_enabled_flag mtl_system_items_kfv.mtl_transactions_enabled_flag%TYPE;
318: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
319: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;
320:
321: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
322: l_mtl_dtl_tbl_out gme_common_pvt.material_details_tab;

Line 319: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;

315: l_item_no VARCHAR2 (2000);
316: l_msg_data VARCHAR2 (2000);
317: l_mtl_txns_enabled_flag mtl_system_items_kfv.mtl_transactions_enabled_flag%TYPE;
318: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
319: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;
320:
321: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
322: l_mtl_dtl_tbl_out gme_common_pvt.material_details_tab;
323: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

Line 347: FROM mtl_system_items_kfv

343: l_diff_qty NUMBER;
344: CURSOR cur_get_item_info (v_org_id NUMBER, v_inventory_item_id NUMBER)
345: IS
346: SELECT mtl_transactions_enabled_flag, concatenated_segments, primary_uom_code
347: FROM mtl_system_items_kfv
348: WHERE inventory_item_id = v_inventory_item_id
349: AND organization_id = v_org_id;
350:
351: create_mo_err EXCEPTION;

Line 1025: FROM mtl_system_items_kfv

1021:
1022: CURSOR cur_item_uoms (v_org_id NUMBER, v_inventory_item_id NUMBER)
1023: IS
1024: SELECT primary_uom_code, secondary_uom_code, concatenated_segments
1025: FROM mtl_system_items_kfv
1026: WHERE organization_id = v_org_id
1027: AND inventory_item_id = v_inventory_item_id;
1028:
1029: get_mo_line_err EXCEPTION;