Oracle Forms (MOSC)

MOSC Banner

Export data

edited Sep 30, 2011 3:24AM in Oracle Forms (MOSC) 6 commentsAnswered
 Dear,

  Please hepl me.

  I make form and i export data from menu.

But it is only display some fields that display

1. Make View

2. datablock, I chooce View

CREATE OR REPLACE VIEW ZSCM_TM_TOOL_LIST_DEPT_V AS
SELECT TD.TOOL_DEPT
, TD.TOOL_NUMBER
, TM.TOOL_DESCRIPTION
, TM.ITEM_CODE
, TM.ITEM_ID
, TM.TOOL_SPECIFICATION
, decode(TD.TOTAL_QUANTITY,0, NULL ,TD.TOTAL_QUANTITY) AS TOTAL_QUANTITY
, decode(SIGN(NVL(TD.TOTAL_QUANTITY,
0) - (NVL(TD.LENDING_QUANTITY,0) +NVL(TD.R_S_QUANTITY,0)+NVL(TD.standby_rs,0)+NVL(TD.standby_loss,0))),1,NVL(TD.TOTAL_QUANTITY,0) - (NVL(TD.LENDING_QUANTITY,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center