[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
sqltxt VARCHAR2(9999); -- SQL select statement
SELECT count(*)
FROM mtl_system_items_b
WHERE inventory_item_id = cp_n_item_id
AND organization_id = nvl(cp_n_org_id,organization_id);
JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
sqltxt := ' Select '||
' BE.TOP_BILL_SEQUENCE_ID "TOP BILL SEQUENCE ID", '||
' BE.BILL_SEQUENCE_ID "BILL SEQUENCE ID", '||
' BE.ORGANIZATION_ID "ORGANIZATION ID", '||
' BE.EXPLOSION_TYPE "EXPLOSION TYPE", '||
' BE.COMPONENT_SEQUENCE_ID "COMPONENT SEQUENCE ID", '||
' BE.COMPONENT_ITEM_ID "COMPONENT ITEM ID", '||
' BE.PLAN_LEVEL "PLAN LEVEL", '||
' BE.EXTENDED_QUANTITY "EXTENDED QUANTITY", '||
' BE.SORT_ORDER "SORT ORDER", '||
' to_char(BE.CREATION_DATE,''DD-MON-YYYY HH24:MI:SS'') "CREATION DATE", '||
' BE.CREATED_BY "CREATED BY", '||
' to_char(BE.LAST_UPDATE_DATE,''DD-MON-YYYY HH24:MI:SS'') "LAST UPDATE DATE", '||
' BE.LAST_UPDATED_BY "LAST UPDATED BY", '||
' BE.TOP_ITEM_ID "TOP ITEM ID", '||
' BE.CONTEXT "CONTEXT", '||
' BE.ATTRIBUTE1 "ATTRIBUTE1", '||
' BE.ATTRIBUTE2 "ATTRIBUTE2", '||
' BE.ATTRIBUTE3 "ATTRIBUTE3", '||
' BE.ATTRIBUTE4 "ATTRIBUTE4", '||
' BE.ATTRIBUTE5 "ATTRIBUTE5", '||
' BE.ATTRIBUTE6 "ATTRIBUTE6", '||
' BE.ATTRIBUTE7 "ATTRIBUTE7", '||
' BE.ATTRIBUTE8 "ATTRIBUTE8", '||
' BE.ATTRIBUTE9 "ATTRIBUTE9", '||
' BE.ATTRIBUTE10 "ATTRIBUTE10", '||
' BE.ATTRIBUTE11 "ATTRIBUTE11", '||
' BE.ATTRIBUTE12 "ATTRIBUTE12", '||
' BE.ATTRIBUTE13 "ATTRIBUTE13", '||
' BE.ATTRIBUTE14 "ATTRIBUTE14", '||
' BE.ATTRIBUTE15 "ATTRIBUTE15", '||
' BE.COMPONENT_QUANTITY "COMPONENT QUANTITY", '||
' BE.SO_BASIS "SO BASIS", '||
' BE.OPTIONAL "OPTIONAL", '||
' BE.MUTUALLY_EXCLUSIVE_OPTIONS "MUTUALLY EXCLUSIVE OPTIONS", '||
' BE.CHECK_ATP "CHECK ATP", '||
' BE.SHIPPING_ALLOWED "SHIPPING ALLOWED", '||
' BE.REQUIRED_TO_SHIP "REQUIRED TO SHIP", '||
' BE.REQUIRED_FOR_REVENUE "REQUIRED FOR REVENUE", '||
' BE.INCLUDE_ON_SHIP_DOCS "INCLUDE ON SHIP DOCS", '||
' BE.INCLUDE_ON_BILL_DOCS "INCLUDE ON BILL DOCS", '||
' BE.LOW_QUANTITY "LOW QUANTITY", '||
' BE.HIGH_QUANTITY "HIGH QUANTITY", '||
' BE.PICK_COMPONENTS "PICK COMPONENTS", '||
' BE.PRIMARY_UOM_CODE "PRIMARY UOM CODE", '||
' BE.PRIMARY_UNIT_OF_MEASURE "PRIMARY UNIT OF MEASURE", '||
' BE.BASE_ITEM_ID "BASE ITEM ID", '||
' BE.ATP_COMPONENTS_FLAG "ATP COMPONENTS FLAG", '||
' BE.ATP_FLAG "ATP FLAG", '||
' BE.BOM_ITEM_TYPE "BOM ITEM TYPE", '||
' BE.PICK_COMPONENTS_FLAG "PICK COMPONENTS FLAG", '||
' BE.REPLENISH_TO_ORDER_FLAG "REPLENISH TO ORDER FLAG", '||
' BE.SHIPPABLE_ITEM_FLAG "SHIPPABLE ITEM FLAG", '||
' BE.CUSTOMER_ORDER_FLAG "CUSTOMER ORDER FLAG", '||
' BE.INTERNAL_ORDER_FLAG "INTERNAL ORDER FLAG", '||
' BE.CUSTOMER_ORDER_ENABLED_FLAG "CUSTOMER ORDER ENABLED FLAG", '||
' BE.INTERNAL_ORDER_ENABLED_FLAG "INTERNAL ORDER ENABLED FLAG", '||
' BE.SO_TRANSACTIONS_FLAG "SO TRANSACTIONS FLAG", '||
' BE.DESCRIPTION "DESCRIPTION", '||
' BE.ASSEMBLY_ITEM_ID "ASSEMBLY ITEM ID", '||
' BE.COMPONENT_CODE "COMPONENT CODE", '||
' BE.LOOP_FLAG "LOOP FLAG", '||
' BE.PARENT_BOM_ITEM_TYPE "PARENT BOM ITEM TYPE", '||
' BE.OPERATION_SEQ_NUM "OPERATION SEQ NUM", '||
' BE.ITEM_NUM "ITEM NUM", '||
' to_char(BE.EFFECTIVITY_DATE,''DD-MON-YYYY HH24:MI:SS'') "EFFECTIVITY DATE",'||
' to_char(BE.DISABLE_DATE,''DD-MON-YYYY HH24:MI:SS'') "DISABLE DATE", '||
' to_char(BE.IMPLEMENTATION_DATE,''DD-MON-YYYY HH24:MI:SS'') "IMPLEMENTATION DATE", '||
' BE.REXPLODE_FLAG "REXPLODE FLAG", '||
' BE.COMMON_BILL_SEQUENCE_ID "COMMON BILL SEQUENCE ID", '||
' BE.COMP_BILL_SEQ_ID "COMP BILL SEQ ID", '||
' BE.COMP_COMMON_BILL_SEQ_ID "COMP COMMON BILL SEQ ID", '||
' BE.EXPLODE_GROUP_ID "EXPLODE GROUP ID", '||
' BE.NUM_COL1 "NUM COL1", '||
' BE.NUM_COL2 "NUM COL2", '||
' BE.NUM_COL3 "NUM COL3", '||
' to_char(BE.DATE_COL1,''DD-MON-YYYY HH24:MI:SS'') "DATE COL1", '||
' to_char(BE.DATE_COL2,''DD-MON-YYYY HH24:MI:SS'') "DATE COL2", '||
' to_char(BE.DATE_COL3,''DD-MON-YYYY HH24:MI:SS'') "DATE COL3", '||
' BE.CHAR_COL1 "CHAR COL1", '||
' BE.CHAR_COL2 "CHAR COL2", '||
' BE.CHAR_COL3 "CHAR COL3", '||
' BE.AUTO_REQUEST_MATERIAL "AUTO REQUEST MATERIAL", '||
' BE.INCLUDE_IN_COST_ROLLUP "INCLUDE IN COST ROLLUP", '||
' BE.COMPONENT_YIELD_FACTOR "COMPONENT YIELD FACTOR", '||
' BE.PLANNING_FACTOR "PLANNING FACTOR", '||
' BE.CHANGE_NOTICE "CHANGE NOTICE", '||
' BE.PARENT_SORT_ORDER "PARENT SORT ORDER" '||
' ,BE.SUGGESTED_VENDOR_NAME "SUGGESTED VENDOR NAME" '||
' ,BE.VENDOR_ID "VENDOR ID" '||
' ,BE.UNIT_PRICE "UNIT PRICE" '||
' ,BE.REQUEST_ID "REQUEST ID" '||
' ,BE.BASIS_TYPE "BASIS TYPE" '||
' ,BE.SOURCE_BILL_SEQUENCE_ID "SOURCE BILL SEQUENCE ID" '||
' ,BE.COMMON_COMPONENT_SEQUENCE_ID "COMMON COMPONENT SEQUENCE ID" '||
' ,BE.COMP_SOURCE_BILL_SEQ_ID "COMP SOURCE BILL SEQ ID" '||
' FROM bom_explosions be WHERE 1=1 ';