is there an API get procedure to grab Qty available field from shop order material availability check screen to use in my lobby data source? Qty Available = Not_Alloc_In_Stock in the oracle backend. I have struggled to find an api to use this field in my data source.
Shop_Material_Alloc_List_API.get_inventory_qty ( contract_ => contract
, part_no_ => part_no
, configuration_id_ => configuration_id
, qty_type_ => 'AVAILTRANSIT'
, supply_code_db_ => supply_code_db
, expiration_control_ => 'NOT EXPIRED'
, supply_control_db_ => 'NETTABLE'
, ownership_type1_db_ => part_ownership_db
, ownership_type2_db_ => decode(part_ownership_db, 'COMPANY OWNED', 'CONSIGNMENT', NULL)
, ownership_type3_db_ => NULL
, ownership_type4_db_ => NULL
, owning_customer_no_ => owning_customer_no
, owning_vendor_no_ => owning_vendor_no
, location_type1_db_ => NULL
, location_type2_db_ => NULL
, location_type3_db_ => NULL
, location_type4_db_ => NULL
, lot_batch_no_ => NULL
, serial_no_ => NULL
, eng_chg_level_ => NULL
, waiv_dev_rej_no_ => NULL
, include_standard_ => decode(supply_code_db, 'IO', 'TRUE', decode(project_id, NULL, 'TRUE', 'FALSE'))
, include_project_ => decode(supply_code_db, 'IO', 'FALSE', decode(project_id, NULL, 'FALSE', 'TRUE'))
, activity_seq_ => activity_seq
, project_id_ => decode(supply_code_db, 'IO', NULL, project_id))
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.