Did you at least perform the test that I was pointing out with this SQL below? This works in the workshop...
select (select phase_num || ' ' || phase_desc from ni_process_phase i where i.ni_proc_phase_seq_num(+) = a.NI_PROC_PHASE_SEQ_NUM) Phase,
b.chain_name, a.CUST_CD_1, a.CUST_CD_2,
(select category_num from cs_category b where b.cs_cat_seq_num(+) = a.CS_CAT_SEQ_NUM) "CS Category", a.REQ_DATE, a.REQSTR_FLAG, a.CUST_WHS_NUM, a.CUST_DEPT,
(select status_code || ' '|| description from buying_status h where h.buying_sts_seq_num(+) = a.BUYING_STS_SEQ_NUM) "Buy Status",
a.UPC_COMM, a.UPC_VEND, a.UPC_CASE, a.UPC_ITEM, a.CUST_GTIN_MFG, a.CUST_GTIN_RTL, a.CUST_PK, a.CUST_SZ, a.CUST_TI, a.CUST_HI, a.VNDR_TI, a.VNDR_HI, a.NEW_ITEM_DESC, a.CREATE_DT, a.VENDOR_SHIP_DATE, a.STORE_ORDER_UNIT, a.NEW_UNTIL_DATE, a.CUST_COMPLETE_DATE, a.FORECAST, a.RNDM_WT_IND,
a.MSTR_CASE, a.CUST_VNDR_NUM, a.CUST_VNDR_NAME, a.CUST_SHIP_FLAG, a.CUST_PVT_LBL_FLAG, a.FULL_PLT_IND, a.CUST_CUBE, a.CUST_COST, a.CUST_AUTH_TO_BUY_FL, a.AUTHORIZATION_DATE, a.ACTIVE_PROPOSAL_FL, a.CASE_HEIGHT, a.CASE_LENGTH, a.CASE_WIDTH, a.CUST_BUYER, a.COMMENTS, a.FIRST_INSTORE_DATE, a.LAST_INSTORE_DATE, a.REASON_FOR_ISSUE, a.ISSUE_DATE, a.VND_PTS_PER_CASE, a.PURCH_MDL_PAL_TIER_FL, a.PURCH_MDL_QTY, a.PURCH_MDL_VND_WHSE_FL,
(select nlsn_ctgry_num || ' ' || nlsn_ctgry_desc from nlsn_ctgry j where j.nlsn_ctgry_seq_num(+) = a.NLSN_CTGRY_SEQ_NUM) Nielsen,
a.FIRM_ORDER_QTY, a.DISTRO_DATE, a.DISTRO_QTY, a.WEIGHT, a.REPLACEMENT_ITEM_FL, ASSOCIATE.NW_LOGIN_ID "Assigned To", NI_ASSIGNEE.ASSIGNOR_COMMENTS, a.COUNTDOWN_START_DATE
from ni_requests a,
(select chain_num, chain_name, chain_seq_num from cs_chain) b,
ASSOCIATE ASSOCIATE,
(select NEW_ITEM_SEQ_NUM, assignor_comments, ASSIGNEE_ASSOC_SEQ_NUM from NI_ASSIGNEE where DATE_UNASSIGNED is null) ni_assignee
where a.NEW_ITEM_SEQ_NUM = NI_ASSIGNEE.NEW_ITEM_SEQ_NUM(+)
and NI_ASSIGNEE.ASSIGNEE_ASSOC_SEQ_NUM = ASSOCIATE.ASSOC_SEQ_NUM(+)
and a.chain_seq_num = b.chain_seq_num and NI_PROC_PHASE_SEQ_NUM = 14
To quote you.....
Your SQL has apex_so.associate. It needs to be associate on apex.oracle.com. But I digress.
Yes it has APEX_SO. that's because I have 2 schemas/workspaces associated with where I'm building my application.