[Home] [Help]
13191: if v_customerclass_flag = 'N' then
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:
13260: g_cond_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) ' || '';
17930: ooh.ordered_date,
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,
18127: WDD.SHIP_METHOD_CODE SHIP_METHOD,
18128: WDD.SHIP_MODEL_COMPLETE_FLAG,
18129: WDD.SHIP_SET_ID,
18130: (select ui_location_code from wsh_locations where wsh_location_id=WDD.SHIP_TO_CONTACT_ID),
18131: (SELECT p.party_name FROM hz_party_sites ps, hz_parties p WHERE p.party_id = ps.party_id AND ps.location_id = wdd.ship_to_location_id AND party_type = 'ORGANIZATION' and rownum=1) SHIP_TO_CUSTOMER,
18132: WDD.SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY,
18133: WDD.SHIPPING_INSTRUCTIONS,
18134: WDD.SRC_REQUESTED_QUANTITY,
18135: WDD.SRC_REQUESTED_QUANTITY_UOM,
18148: wwh.wave_firmed_flag,
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,