DBA Data[Home] [Help]

APPS.GME_MOVE_ORDERS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 367: l_mtl_txns_enabled_flag mtl_system_items_kfv.mtl_transactions_enabled_flag%TYPE;

363: l_from_uom VARCHAR2 (3);
364: l_to_uom VARCHAR2 (3);
365: l_item_no VARCHAR2 (2000);
366: l_msg_data VARCHAR2 (2000);
367: l_mtl_txns_enabled_flag mtl_system_items_kfv.mtl_transactions_enabled_flag%TYPE;
368: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
369: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;
370:
371: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;

Line 368: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

364: l_to_uom VARCHAR2 (3);
365: l_item_no VARCHAR2 (2000);
366: l_msg_data VARCHAR2 (2000);
367: l_mtl_txns_enabled_flag mtl_system_items_kfv.mtl_transactions_enabled_flag%TYPE;
368: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
369: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;
370:
371: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
372: l_mtl_dtl_tbl_out gme_common_pvt.material_details_tab;

Line 369: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;

365: l_item_no VARCHAR2 (2000);
366: l_msg_data VARCHAR2 (2000);
367: l_mtl_txns_enabled_flag mtl_system_items_kfv.mtl_transactions_enabled_flag%TYPE;
368: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
369: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;
370:
371: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
372: l_mtl_dtl_tbl_out gme_common_pvt.material_details_tab;
373: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

Line 397: FROM mtl_system_items_kfv

393: l_diff_qty NUMBER;
394: CURSOR cur_get_item_info (v_org_id NUMBER, v_inventory_item_id NUMBER)
395: IS
396: SELECT mtl_transactions_enabled_flag, concatenated_segments, primary_uom_code
397: FROM mtl_system_items_kfv
398: WHERE inventory_item_id = v_inventory_item_id
399: AND organization_id = v_org_id;
400:
401: create_mo_err EXCEPTION;

Line 1222: FROM mtl_system_items_kfv

1218:
1219: CURSOR cur_item_uoms (v_org_id NUMBER, v_inventory_item_id NUMBER)
1220: IS
1221: SELECT primary_uom_code, secondary_uom_code, concatenated_segments
1222: FROM mtl_system_items_kfv
1223: WHERE organization_id = v_org_id
1224: AND inventory_item_id = v_inventory_item_id;
1225:
1226: get_mo_line_err EXCEPTION;