Skip to main content
Question

API to grab QtyAvailable (Not_alloc_in_stock) from Shop Order Material Availability Check

  • January 24, 2025
  • 1 reply
  • 23 views

Forum|alt.badge.img+2

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.

 

 

 

1 reply

Forum|alt.badge.img+14

@blake.hamlin  I think it’s Shop_Material_Alloc_List_API.get_inventory_qty, but it’s kind of “ugly” to include in a Lobby…

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))


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings