1) Establish a PP material number with PL / SQL stock
Create or replace view inventory_part_in_stock_pp asselect contract ???????????????????????????????????????????????????????????????????????? ??????????? part_no, ?????? configure_id ????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ???????????? log, ?????? lot_batch_no ???????????????????????????????????????????? serial_no ????? serial_no ?????? serial_no ?? ??????????????????? serial_no, ?????? eNG_CHG_LEVEL ????????????????? ENG_CHG_LEVEL,??? ??? waiv_dev_rej_no ??????????????? WAIV_DEV_REJ_NO, ?????? vendor_no ????????????????????? Vendor_NO , ?????? avg_unit_transit_cost ????????? avg_unit_transit_cost, ?????? count_variance ???????????????? count_variance, ?????? DEL_TYPE ????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ?? Department, ???????????????????????????????????????????????????????????????????????????????????????????? SubStrB (Inventory_Part_FLAG), 1,200) Freeze_Flag, ??? ??? freeze_flag ???????????????????????????? ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ?? Last_count_date ??????????????? L AST_COUNT_DATE, ?????? Location_class ???????????????? Location_class, ?????? SubStrB (INVENTORY_LOCATION_TYPE_API.DECODE (Location_Type), 1,200) Location_Type, ????? ?? Location_type ????????????????? Location_Type_DB, ?????? Low_level_code ??????????????? Low_level_code,??? ??? ownership ????????????????????? ownership, ?????? qty_in_Transit ??????????????????????????? Qty_in_transit, ?????? qty_onhand ??????????????????? qty_reserved ?????????????? ?????? qty_reserved, ?????? receipt_date ?????????????????? Receipt_date, ?????? Source ???????? ????????????????? Source, ?????? warehouse ????????????????????? ahouse,?? ???? bay_no ????????????????????????? a row_no ???????????? ???????????? row_no, ?????? tier_no ??????????????????????? tier_no, ???? ??
BIN_NO ???????????????????????? bin_no, ?????? Availability_Control_ID ??????? Availability_Control_ID, ?????? RowID ???????????????????????? objid, ?????? LTRIM (LPAD (TO_CHAR (ROWVERSION, 'YYYYMMMDHH24MISS'), 2000)?? ?????????????????? ObjversionFrom ?? inventory_part_in_stock_tabwhere part_no like '7%' and (not (???? (qty_onhand = 0) ????????? ? (qty_reserved = 0) ????????? and? (qty_in_transit = 0) ????????) ???) with ?? r on 中
2) Report the relevant information in the table; the query conditions are: the library, start number, end bill, start date, end date parameter setting: BooleanVar BSQL: = true;
{? SLocationNo} if <> ''? Then bSQL:; {? SBeginPartNo} = bSQL AND ({? SLocationNo} {INVENTORY_PART_IN_STOCK_PP.LOCATION_NO} like) if <> '' then bSQL: = bSQL AND ({INVENTORY_PART_IN_STOCK_PP.PART_NO? }> = {sBeginPartNo}); if {sEndPartNo} <> '' then bSQL:?? = bSQL AND ({INVENTORY_PART_IN_STOCK_PP.PART_NO} <= {sEndPartNo}); bSQL:?? = bSQL AND (Date ({INVENTORY_PART_IN_STOCK_PP. Receipt_date})> = {? Dtbegindate}; bsql: = bsql and (Date ({inventory_part_in_stock_pp.receipt_date}) <= {? DtendDate};
BSQL;
3) PP material number list: The first group: 号; Second group: Bottom number
4) PP library list: The first group: the library position; the second group:
Last display result:
?
