Could you please post your table data here? It seems you dont have the relevant data as per your WHERE conditions to show any output.
SQL> desc docl
Name Null? Type
------------------------------- -------- ----
C_ID NOT NULL NUMBER(12)
DOC_NO NOT NULL VARCHAR2(25)
DOC_DATE DATE
LINE_ID NOT NULL NUMBER(12)
PRODUCT_CODE VARCHAR2(25)
ACT_DUTY_COST NUMBER(19,4)
ACT_FOB_COST NUMBER(19,4)
ACT_SHIP_COST NUMBER(19,4)
ADJ_UNIT_COST NUMBER(19,4)
ADJ_DATE DATE
ANALYSIS_CODE_1 VARCHAR2(25)
ANALYSIS_CATEGORY_1 VARCHAR2(10)
ANALYSIS_CODE_2 VARCHAR2(25)
ANALYSIS_CATEGORY_2 VARCHAR2(10)
ANALYSIS_CODE_3 VARCHAR2(25)
ANALYSIS_CATEGORY_3 VARCHAR2(10)
BIN_LOCATION VARCHAR2(25)
DIM_UOM_CODE VARCHAR2(10)
DISC_1 NUMBER(4,2)
DISC_2 NUMBER(4,2)
DOC_TYPE VARCHAR2(10)
EXP_DUTY_COST NUMBER(19,4)
EXP_FOB_COST NUMBER(19,4)
EXP_SHIP_COST NUMBER(19,4)
ITEM_DIM_1 NUMBER(19,3)
ITEM_DIM_2 NUMBER(19,3)
ITEM_DIM_3 NUMBER(19,3)
LINE_NO NUMBER(12)
QTY_BACKORDERED NUMBER(14,2)
QTY_CHANGE NUMBER(14,2)
QTY_ORDERED NUMBER(14,2)
QTY_OUTSTANDING NUMBER(14,2)
QTY_REJECTED NUMBER(14,2)
QTY_SHIPPED NUMBER(14,2)
REC_DATE_ACTUAL DATE
REC_DATE_PROMISED DATE
REC_DATE_REQUESTED DATE
SERIAL_NO_1 VARCHAR2(25)
SERIAL_NO_2 VARCHAR2(25)
SERIAL_NO_3 VARCHAR2(25)
SHIP_DATE_ACTUAL DATE
SHIP_DATE_PROMISED DATE
SHIP_DATE_REQUESTED DATE
UNIT_COST NUMBER(19,4)
UNIT_PRICE NUMBER(19,3)
DOC_STATUS VARCHAR2(1)
DOC_ID NUMBER(12)
PRODUCT_DESCRIPTION VARCHAR2(80)
QTY_ALLOCATED NUMBER(14,2)
CROSS_REF_LINE_ID NUMBER(12)
TAX_CODE VARCHAR2(10)
CROSS_REF_DOC_ID NUMBER(12)
CONV_FACTOR NUMBER(19,4)
LINE_STATUS VARCHAR2(1)
NEW_AV_COST NUMBER(19,4)
LIST_PRICE NUMBER(19,3)
LIST_DISCOUNT NUMBER(4,2)
REC_LINE_ID NUMBER(12)
QTY_INVOICE NUMBER(14,2)
EXP_SURC_COST NUMBER(19,4)
ACT_SURC_COST NUMBER(19,4)
SUP_ACK_REF VARCHAR2(25)
SUP_ACK_DATE DATE
TOTAL_COST NUMBER(19,4)
TOTAL_PRICE NUMBER(19,3)
PURC_CONV_FACTOR NUMBER(12,6)
UOM_CODE VARCHAR2(10)
PICK_UOM VARCHAR2(10)
INVOICE_PRICE NUMBER(19,3)
QTY_PICK NUMBER(14,2)
ALT_UOM VARCHAR2(10)
QTY_ALT NUMBER(14,2)
INSURANCE_AMOUNT NUMBER(19,4)
TAX_RATE NUMBER(4,2)
UNIT_TAX NUMBER(19,3)
STOCKED_INDICATOR VARCHAR2(1)
INSP_REQ VARCHAR2(1)
INSP_STATUS VARCHAR2(1)
INSP_DATE DATE
REJ_REASON VARCHAR2(10)
RECLAIM_TAX VARCHAR2(1)
CRITICAL VARCHAR2(1)
SOURCE_CODE VARCHAR2(10)
UNIT_DISC NUMBER(19,4)
TYPE_CODE VARCHAR2(10)
DISCIPLINE VARCHAR2(10)
EQUIPMENT VARCHAR2(25)
STANDARD_COST NUMBER(19,4)
SQL> spool off
SQL> desc product_base
Name Null? Type
------------------------------- -------- ----
SHORT_NAME NOT NULL VARCHAR2(25)
ABC_ANALYSIS_CODE VARCHAR2(10)
ABC_ANALYSIS_CODE_DATE DATE
ACTIVITY_INDICATOR VARCHAR2(1)
AGENCY_CODE VARCHAR2(25)
ANALYSIS_CATEGORY_1 VARCHAR2(10)
ANALYSIS_CODE_1 VARCHAR2(25)
ANALYSIS_CATEGORY_2 VARCHAR2(10)
ANALYSIS_CODE_2 VARCHAR2(25)
ANALYSIS_CATEGORY_3 VARCHAR2(10)
ANALYSIS_CODE_3 VARCHAR2(25)
AVERAGE_COST NUMBER(19,4)
BALANCE_FWD_DATE DATE
BALANCE_FWD_QTY NUMBER(14,2)
CONTROLLED_INDICATOR VARCHAR2(1)
C_ID NOT NULL NUMBER(12)
CYCLE_COUNT_CODE VARCHAR2(10)
DATE_CREATED DATE
DATE_LAST_COUNTED DATE
DATE_LAST_ISSUE DATE
DATE_LAST_RECEIPT DATE
DATE_LAST_SALE DATE
DATE_LAST_TRANSFER DATE
DEFAULT_BIN_LOCATION VARCHAR2(25)
DIMENSION_UOM_CODE VARCHAR2(25)
LAST_COST NUMBER(19,4)
MINIMUM_MARGIN NUMBER(5,2)
PRODUCT_CATEGORY_CODE NOT NULL VARCHAR2(25)
PRODUCT_CODE NOT NULL VARCHAR2(25)
PRODUCT_DESCRIPTION NOT NULL VARCHAR2(80)
QTY_ALLOCATED NUMBER(14,2)
QTY_ON_BACKORDER_SUPPLIER NUMBER(14,2)
QTY_ON_HAND NUMBER(14,2)
QTY_ON_ORDER NUMBER(14,2)
STANDARD_COST NUMBER(19,4)
STOCKED_INDICATOR VARCHAR2(1)
STOCKED_UOM_CODE VARCHAR2(10)
SUPERSEDED_BY_PRODUCT VARCHAR2(30)
SUPERSESSION_DATE DATE
SUPERSEDED_PRODUCT VARCHAR2(30)
TARIFF_CODE VARCHAR2(25)
TAX_CODE VARCHAR2(10)
UNIT_DIM_1 NUMBER(19,3)
UNIT_DIM_2 NUMBER(19,3)
UNIT_DIM_3 NUMBER(19,3)
UNIT_WEIGHT NUMBER(19,3)
WEIGHT_UOM_CODE VARCHAR2(10)
WRITE_DOWN_INDICATOR VARCHAR2(1)
PRICE NUMBER(19,4)
PRODUCT_IND VARCHAR2(1)
DIVISION VARCHAR2(25)
SALES_CONV_FACTOR NUMBER(12,6)
SALES_UOM_CODE VARCHAR2(25)
FUTURE_PRICE NUMBER(19,3)
MTD_USAGE NUMBER(14,2)
MTD_VALUE NUMBER(19,4)
MARKUP_PCT NUMBER(5,2)
GROSS_WEIGHT NUMBER(19,3)
ENT_AV_IND VARCHAR2(1)
SQL> spool off
These are the descriptions of the tables I am trying to extract information from,
does it help?