摘要： 在Oracle Application中，standard 功能是调用下面API来计算Onhand Quantity的：inv_quantity_tree_pub.query_quantities ( p_api_version_number = 1.0, p_init_msg_lst = 'F', x_return_status = x_return_status, x_msg_count = x_msg_count, x_msg_data = x_msg_data, p_organization_id = p_organization_id, p_inventory_item_ 阅读全文

摘要： WIP-离散-离散任务任务Kevin13这张工单的所有组件的信息：select msi.segment1, msi.description, wdj.class_code, wdj.status_type, wdj.start_quantity, wdj.net_quantity, wdj.quantity_completed, wdj.quantity_scrapped, wdj.scheduled_start_date, wdj.scheduled_completion_date, wro.operation_seq_num, dept.department_code, wro.dat 阅读全文

摘要： 查询某个原物料下的子组件：select level, t.* from (select items1.segment1 segment1_m, items1.inventory_item_id m_id, items1.description description_m, materials.bill_sequence_id, components.item_num, components.ope... 阅读全文