[Home] [Help]
13192: g_Unreleased_SQL := g_Unreleased_SQL ||
13193: ',(select cust_Acct.customer_class_code customer_class_code,
13194: cust_acct.cust_account_id cust_account_id from
13195: hz_parties PARTY
13196: , hz_cust_accounts CUST_ACCT
13197: where party.party_id = cust_acct.party_id
13198: and cust_acct.status = ''A'') CUSTOMER_CLASS ';
13199:
13200: g_WHERE_SQL := g_WHERE_SQL ||
13261:
13262: IF (g_customer_class_id is not null) THEN
13263: g_cond_SQL := g_Cond_SQL || ' AND WDD.CUSTOMER_ID IN (select cust_acct.cust_account_id
13264: from hz_parties PARTY
13265: , hz_cust_accounts CUST_ACCT
13266: where party.party_id = cust_acct.party_id
13267: and cust_acct.status = ''A''' ||
13268: ' AND cust_Acct.customer_class_code = :X_CUSTOMER_CLASS_ID) ' || '';
13269: print_debug('g_cond_sql after customer class code :' || g_cond_sql,
17918: cust_po_number,
17919: ordered_date,
17920: order_request_date,
17921: order_progress)
17922: select /*+ use_nl(CUST_ACCT) index(CUST_ACCT HZ_CUST_ACCOUNTS_U1) */ ooh.order_number,
17923: HP.PARTY_NAME CUSTOMER,
17924: wl.planned_fill_rate,
17925: wl.release_fill_rate,
17926: wl.pick_fill_rate,
17931: ooh.request_date order_request_date,
17932: wl.order_progress
17933: from oe_order_headers_all ooh,
17934: HZ_PARTIES HP,
17935: hz_cust_accounts CUST_ACCT,
17936: oe_transaction_types_tl ott,
17937: (select wwlv.source_header_id,
17938: sum(wwlv.requested_quantity*wwlv.planned_fill_rate)/decode(sum(wwlv.requested_quantity),0,1,sum(wwlv.requested_quantity)) planned_fill_rate,
17939: sum(wwlv.requested_quantity*wwlv.release_fill_rate)/decode(sum(wwlv.requested_quantity),0,1,sum(wwlv.requested_quantity)) release_fill_rate,
18149: wwl.message
18150: from
18151: WSH_DELIVERY_DETAILS WDD,
18152: HZ_PARTIES HP,
18153: hz_cust_accounts CUST_ACCT,
18154: OE_ORDER_LINES_ALL OOL,
18155: wms_wp_wave_headers_b WWH,
18156: WMS_WP_WAVE_LINES WWL,
18157: WSH_NEW_DELIVERIES WND,