eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_VALIDATE_PVT dependencies on DUAL

Line 5625: SELECT 1 FROM DUAL WHERE exists

5621: P_HEADER VARCHAR2(1);
5622:
5623:
5624: CURSOR C_FOB(p_lookup_code varchar2)is
5625: SELECT 1 FROM DUAL WHERE exists
5626: (
5627: SELECT meaning fob
5628: FROM ar_lookups
5629: WHERE lookup_type = 'FOB'

Line 5637: SELECT 1 FROM DUAL WHERE EXISTS

5633: AND lookup_code = p_lookup_code
5634: ) ;
5635:
5636: CURSOR C_SHIPMENT_PRIORITY_CODE(p_shipment_priority_code varchar2) IS
5637: SELECT 1 FROM DUAL WHERE EXISTS
5638: (
5639: SELECT meaning shipment_priority
5640: FROM oe_lookups
5641: WHERE lookup_type = 'SHIPMENT_PRIORITY'

Line 5648: SELECT 1 FROM DUAL WHERE exists

5644: AND lookup_code = p_shipment_priority_code
5645: );
5646:
5647: CURSOR C_SALESCHANNEL(p_lookup_code varchar2) is
5648: SELECT 1 FROM DUAL WHERE exists
5649: (
5650: SELECT lookup_code
5651: FROM fnd_lookup_values_vl
5652: WHERE lookup_type = 'SALES_CHANNEL'

Line 5662: SELECT 1 FROM DUAL WHERE exists

5658: );
5659:
5660:
5661: CURSOR C_QOTHDDET_CURRENCY_NOT_NULL(p_currency_code varchar2,p_price_list_id varchar2) is
5662: SELECT 1 FROM DUAL WHERE exists
5663: (
5664: SELECT d.currency_code currency_code
5665: FROM Fnd_currencies d
5666: ,qp_currency_details b

Line 5692: SELECT 1 FROM DUAL WHERE exists

5688: );
5689:
5690:
5691: CURSOR C_QOTHDDET_CURRENCY_NULL(p_currency_code varchar2) is
5692: SELECT 1 FROM DUAL WHERE exists
5693: (
5694: SELECT b.currency_code
5695: FROM fnd_currencies b
5696: WHERE b.currency_flag = 'Y'

Line 5704: SELECT 1 FROM DUAL WHERE exists

5700: );
5701:
5702: --New Cursor(s) start
5703: CURSOR C_PAYMENT_TYPE(p_lookup_code varchar2) is --Payment Type
5704: SELECT 1 FROM DUAL WHERE exists
5705: (
5706: SELECT Lookup_Code Payment_Type_Code
5707: from ASO_LOOKUPS
5708: WHERE LOOKUP_TYPE = 'ASO_PAYMENT_TYPE'

Line 5717: SELECT 1 FROM DUAL WHERE exists

5713: and lookup_code = p_lookup_code
5714: );
5715:
5716: CURSOR C_CREDIT_CARD_TYPE(p_credit_card_code varchar2) is --Credit Card Type
5717: SELECT 1 FROM DUAL WHERE exists
5718: (
5719: SELECT CARD_ISSUER_CODE credit_card_code
5720: FROM IBY_CREDITCARD_ISSUERS_V
5721: where CARD_ISSUER_CODE = p_credit_card_code

Line 5725: SELECT 1 FROM DUAL WHERE exists

5721: where CARD_ISSUER_CODE = p_credit_card_code
5722: );
5723:
5724: CURSOR C_DEMAND_CLASS(p_lookup_code varchar2) is --Demand Class
5725: SELECT 1 FROM DUAL WHERE exists
5726: (
5727: Select lookup_code Demand_Class_Code,
5728: meaning Demand_Class,
5729: description

Line 5740: SELECT 1 FROM DUAL WHERE exists

5736: And lookup_code = p_lookup_code
5737: );
5738:
5739: CURSOR C_REQUEST_DATE_TYPE(p_lookup_code varchar2) is --Request Date Type
5740: SELECT 1 FROM DUAL WHERE exists
5741: (
5742: Select lookup_code
5743: from oe_lookups
5744: where lookup_type='REQUEST_DATE_TYPE'

Line 5752: SELECT 1 FROM DUAL WHERE exists

5748: and trunc(nvl(end_date_active,sysdate))
5749: );
5750:
5751: CURSOR C_REQUEST_DATE(p_request_date date) is --Request Date(Confirm it)
5752: SELECT 1 FROM DUAL WHERE exists
5753: (
5754: select 1 from dual where trunc(p_request_date) >= trunc(sysdate)
5755: );
5756:

Line 5754: select 1 from dual where trunc(p_request_date) >= trunc(sysdate)

5750:
5751: CURSOR C_REQUEST_DATE(p_request_date date) is --Request Date(Confirm it)
5752: SELECT 1 FROM DUAL WHERE exists
5753: (
5754: select 1 from dual where trunc(p_request_date) >= trunc(sysdate)
5755: );
5756:
5757: CURSOR C_OPERATING_UNIT(p_org_id varchar2) is
5758: select DECODE(MO_GLOBAL.CHECK_ACCESS(p_org_id),'Y','Y','N',NULL,NULL) from dual ;

Line 5758: select DECODE(MO_GLOBAL.CHECK_ACCESS(p_org_id),'Y','Y','N',NULL,NULL) from dual ;

5754: select 1 from dual where trunc(p_request_date) >= trunc(sysdate)
5755: );
5756:
5757: CURSOR C_OPERATING_UNIT(p_org_id varchar2) is
5758: select DECODE(MO_GLOBAL.CHECK_ACCESS(p_org_id),'Y','Y','N',NULL,NULL) from dual ;
5759:
5760:
5761: CURSOR C_CHARGE_PERIODICITY_CODE(p_periodicity_code VARCHAR2,p_periodicity_profile VARCHAR2) is --CHARGE_PERIODICITY
5762: SELECT 1 FROM DUAL WHERE exists

Line 5762: SELECT 1 FROM DUAL WHERE exists

5758: select DECODE(MO_GLOBAL.CHECK_ACCESS(p_org_id),'Y','Y','N',NULL,NULL) from dual ;
5759:
5760:
5761: CURSOR C_CHARGE_PERIODICITY_CODE(p_periodicity_code VARCHAR2,p_periodicity_profile VARCHAR2) is --CHARGE_PERIODICITY
5762: SELECT 1 FROM DUAL WHERE exists
5763: (
5764: Select distinct uom_code
5765: From MTL_UNITS_OF_MEASURE_VL --Changed mtl_uom_conversions to MTL_UNITS_OF_MEASURE_VL 05/10/2005(Yogeshwar)
5766: Where uom_class=p_periodicity_profile

Line 5771: SELECT 1 FROM DUAL WHERE exists

5767: And uom_code=p_periodicity_code
5768: );
5769:
5770: CURSOR C_AUTOMATIC_PRICING(p_lookup_code varchar2) IS --Auotmatic Pricing
5771: SELECT 1 FROM DUAL WHERE exists
5772: (
5773: select lookup_code
5774: from aso_lookups
5775: where lookup_type='ASO_PRICE_TAX_COMPUTE_OPTION'

Line 5785: SELECT 1 FROM DUAL WHERE exists

5781: );
5782:
5783:
5784: CURSOR C_AUTOMATIC_TAX(p_lookup_code varchar2) IS --Auotmatic Tax
5785: SELECT 1 FROM DUAL WHERE exists
5786: (
5787: select lookup_code
5788: from aso_lookups
5789: where lookup_type='ASO_PRICE_TAX_COMPUTE_OPTION'

Line 5811: SELECT 1 FROM DUAL WHERE EXISTS

5807: ) is
5808:
5809:
5810: CURSOR C_VALIDATE_PHONE_CONTACT IS
5811: SELECT 1 FROM DUAL WHERE EXISTS
5812: (
5813: SELECT phone.contact_point_id
5814: FROM HZ_CONTACT_POINTS phone,
5815: HZ_PARTIES hp

Line 5827: SELECT 1 FROM DUAL WHERE EXISTS

5823: );
5824:
5825:
5826: CURSOR C_VALIDATE_PHONE_CUSTOMER IS -- when customer is specified and party_type is of type 'PERSON'
5827: SELECT 1 FROM DUAL WHERE EXISTS
5828: (
5829:
5830: SELECT phone.contact_point_id
5831: FROM HZ_CONTACT_POINTS phone,

Line 5917: SELECT 1 FROM DUAL WHERE EXISTS

5913: -- p_flag possible values END-
5914: -- p_header possible values Y and N
5915:
5916: CURSOR C_CUST_PARTY IS
5917: SELECT 1 FROM DUAL WHERE EXISTS
5918: (
5919: SELECT hp.party_name --(Base Query)
5920: FROM HZ_PARTIES HP
5921: WHERE hp.party_type in ('PERSON','ORGANIZATION')

Line 5929: SELECT 1 FROM DUAL WHERE EXISTS

5925:
5926:
5927: -- When ASN_CUST_ACCESS = T and manager_flag = 'Y'
5928: CURSOR C_CUST_PARTY_MANAGER IS
5929: SELECT 1 FROM DUAL WHERE EXISTS
5930: (
5931: select null
5932: from HZ_PARTIES P
5933: where P.status = 'A'

Line 5976: SELECT 1 FROM DUAL WHERE EXISTS

5972:
5973: -- When ASN_CUST_ACCESS = T and manager_flag = 'N'
5974:
5975: CURSOR C_CUST_PARTY_NO_MANAGER IS
5976: SELECT 1 FROM DUAL WHERE EXISTS
5977: (
5978:
5979: select P.party_name
5980: from HZ_PARTIES P

Line 5995: select 1 from dual where exists

5991:
5992: );
5993:
5994: Cursor C_Mgr_Check Is --to check the manager flag
5995: select 1 from dual where exists
5996: (
5997: SELECT MGR.group_id
5998: FROM jtf_rs_rep_managers MGR ,
5999: jtf_rs_group_usages U

Line 6223: SELECT 1 FROM DUAL WHERE EXISTS

6219: -- QOTHDDET_MAIN.sold_to_cust_party_id --> p_quote_header_rec.cust_party_id
6220:
6221: --CURSOR C_BILL_SHIP_CONTACT_NAME IS
6222: CURSOR C_CONTACT_NAME IS
6223: SELECT 1 FROM DUAL WHERE EXISTS
6224: (
6225: SELECT hp_contact.party_name
6226: FROM HZ_PARTIES hp_contact,
6227: HZ_RELATIONSHIPS hp_rltn

Line 6378: select 1 from DUAL where exists

6374: -- p_flag possible values : BILL or SHIP
6375: -- p_header possible values : Y or N
6376:
6377: Cursor C_Mgr_Check Is --to check the manager flag
6378: select 1 from DUAL where exists
6379: (
6380: SELECT MGR.group_id
6381: FROM jtf_rs_rep_managers MGR ,
6382: jtf_rs_group_usages U

Line 6395: SELECT 1 FROM DUAL WHERE EXISTS

6391:
6392: --CURSOR C_INVOICE_TO_CUST_PARTY_NAME_FLD IS
6393: CURSOR C_INVOICE_TO_CUSTOMER IS
6394: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6395: SELECT 1 FROM DUAL WHERE EXISTS
6396: (
6397: SELECT hp.party_id --Removed HZ_CUST_ACCOUNTS ca
6398: FROM HZ_PARTIES hp
6399: WHERE hp.party_type in ('PERSON','ORGANIZATION')

Line 6419: SELECT 1 FROM DUAL WHERE EXISTS

6415:
6416: CURSOR C_SHIP_TO_CUSTOMER IS
6417: --CURSOR C_SHIP_TO_CUST_PARTY_NAME_FLD IS
6418: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6419: SELECT 1 FROM DUAL WHERE EXISTS
6420: (
6421: SELECT hp.party_id
6422: FROM HZ_PARTIES hp
6423: WHERE hp.party_id = p_cust_party_id

Line 6442: SELECT 1 FROM DUAL WHERE EXISTS

6438:
6439: -- When ASO_ENFORCE_ACCOUNT_RELATIONSHIPS = 'N' and ASN_CUST_ACCESS = T
6440: --CURSOR C_CUST_PARTY_NAME1 IS
6441: CURSOR C_CUSTOMER IS
6442: SELECT 1 FROM DUAL WHERE EXISTS
6443: (
6444: SELECT hp.party_id
6445: FROM HZ_PARTIES hp
6446: WHERE hp.party_type in ('PERSON','ORGANIZATION')

Line 6454: SELECT 1 FROM DUAL WHERE EXISTS

6450:
6451: -- When ASO_ENFORCE_ACCOUNT_RELATIONSHIPS = 'N' and ASN_CUST_ACCESS = T and manager_flag = 'Y'
6452: --CURSOR C_CUST_PARTY_NAME2 IS
6453: CURSOR C_CUSTOMER_MANAGER IS
6454: SELECT 1 FROM DUAL WHERE EXISTS
6455: (
6456: select P.party_id
6457: from HZ_PARTIES P
6458: where P.status = 'A'

Line 6497: SELECT 1 FROM DUAL WHERE EXISTS

6493:
6494: -- When ASO_ENFORCE_ACCOUNT_RELATIONSHIPS = 'N' and ASN_CUST_ACCESS = T and manager_flag = 'N'
6495:
6496: CURSOR C_CUSTOMER_NO_MANAGER IS
6497: SELECT 1 FROM DUAL WHERE EXISTS
6498: (
6499:
6500: select P.status
6501: from HZ_PARTIES P

Line 6821: select 1 from dual where exists

6817: -- p_flag possible values : BILL or SHIP
6818: -- p_header possible values : Y or N
6819:
6820: Cursor C_Mgr_Check Is --to check the manager flag
6821: select 1 from dual where exists
6822: (
6823: SELECT MGR.group_id
6824: FROM jtf_rs_rep_managers MGR ,
6825: jtf_rs_group_usages U

Line 6837: --SELECT 1 FROM DUAL WHERE EXISTS

6833: );
6834:
6835: CURSOR C_INVOICE_TO_CUST_ACCOUNT IS
6836: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6837: --SELECT 1 FROM DUAL WHERE EXISTS
6838: --(
6839: -- SELECT ca.account_number
6840: -- FROM HZ_PARTIES hp,
6841: -- HZ_CUST_ACCOUNTS ca,

Line 6858: SELECT 1 FROM DUAL WHERE EXISTS

6854: -- AND trunc(nvl(ca.account_activation_date,sysdate)) <= trunc(sysdate)
6855: -- AND trunc(nvl(ca.account_termination_date,sysdate)) >= trunc(sysdate)
6856: -- AND car.status = 'A'
6857: --) ;
6858: SELECT 1 FROM DUAL WHERE EXISTS
6859: (
6860: SELECT ca.account_number
6861: FROM HZ_PARTIES hp,
6862: HZ_CUST_ACCOUNTS ca,

Line 6896: --SELECT 1 FROM DUAL WHERE EXISTS

6892:
6893:
6894: CURSOR C_SHIP_TO_CUST_ACCOUNT IS
6895: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6896: --SELECT 1 FROM DUAL WHERE EXISTS
6897: --(
6898: -- SELECT ca.account_number
6899: -- FROM HZ_PARTIES hp,
6900: -- HZ_CUST_ACCOUNTS ca,

Line 6949: SELECT 1 FROM DUAL WHERE EXISTS

6945:
6946:
6947: -- When ASO_ENFORCE_ACCOUNT_RELATIONSHIPS = 'N' and ASN_CUST_ACCESS = F
6948: CURSOR C_CUST_ACCOUNT IS
6949: SELECT 1 FROM DUAL WHERE EXISTS
6950: (
6951: SELECT ca.account_number
6952: FROM HZ_PARTIES hp,
6953: HZ_CUST_ACCOUNTS ca

Line 6967: SELECT 1 FROM DUAL WHERE EXISTS

6963:
6964: -- When ASO_ENFORCE_ACCOUNT_RELATIONSHIPS = 'N' and ASN_CUST_ACCESS = T and manager_flag = 'Y'
6965:
6966: CURSOR C_CUST_ACCOUNT_MANAGER IS
6967: SELECT 1 FROM DUAL WHERE EXISTS
6968: (
6969: select null
6970: from HZ_PARTIES P
6971: ,HZ_CUST_ACCOUNTS CA

Line 7018: SELECT 1 FROM DUAL WHERE EXISTS

7014:
7015: -- When ASO_ENFORCE_ACCOUNT_RELATIONSHIPS = 'N' and ASN_CUST_ACCESS = T and manager_flag = 'N'
7016:
7017: CURSOR C_CUST_ACCOUNT_NO_MANAGER IS
7018: SELECT 1 FROM DUAL WHERE EXISTS
7019: (
7020:
7021: select CA.account_number
7022: from HZ_PARTIES HP ,

Line 7330: SELECT 1 FROM DUAL WHERE EXISTS

7326:
7327: l_data_exists VARCHAR2(10) ;
7328:
7329: CURSOR C_PARTY_ADDRESS IS
7330: SELECT 1 FROM DUAL WHERE EXISTS
7331: (
7332: SELECT site.party_site_id
7333: FROM HZ_PARTIES hp,
7334: HZ_PARTY_SITES site

Line 7344: SELECT 1 FROM DUAL WHERE EXISTS

7340: );
7341:
7342: --CURSOR C_PARTY_ADDRESS2 IS
7343: CURSOR C_CUST_PARTY_ADDRESS_NOT_NULL IS
7344: SELECT 1 FROM DUAL WHERE EXISTS
7345: (
7346: SELECT site.party_site_id
7347: FROM HZ_PARTIES hp,
7348: HZ_PARTY_SITES site

Line 7358: SELECT 1 FROM DUAL WHERE EXISTS

7354: );
7355:
7356: --CURSOR C_PARTY_ADDRESS3 IS
7357: CURSOR C_CUSTOMER_ADDRESS_NOT_NULL IS
7358: SELECT 1 FROM DUAL WHERE EXISTS
7359: (
7360:
7361: SELECT site.party_site_id
7362: FROM HZ_PARTIES hp,

Line 7700: select 1 from dual where exists

7696: --:PARAMETER.user_resource_id-->p_resource_id-->p_quote_header_rec.resource_id
7697:
7698:
7699: Cursor C_Mgr_Check Is --to check the manager flag
7700: select 1 from dual where exists
7701: (
7702: SELECT MGR.group_id
7703: FROM jtf_rs_rep_managers MGR ,
7704: jtf_rs_group_usages U

Line 7716: SELECT 1 FROM DUAL WHERE EXISTS

7712: );
7713:
7714:
7715: CURSOR C_SOLD_TO_ACCOUNT IS
7716: SELECT 1 FROM DUAL WHERE EXISTS
7717: (
7718: SELECT ca.account_number
7719: FROM HZ_PARTIES HP,
7720: HZ_CUST_ACCOUNTS CA

Line 7731: SELECT 1 FROM DUAL WHERE EXISTS

7727: AND ca.cust_account_id = p_cust_acct_id
7728: );
7729:
7730: CURSOR C_SOLD_TO_ACCOUNT_NO_MANAGER IS
7731: SELECT 1 FROM DUAL WHERE EXISTS
7732: (
7733: select ca.account_number
7734: from HZ_PARTIES P
7735: , HZ_CUST_ACCOUNTS CA

Line 7754: SELECT 1 FROM DUAL WHERE EXISTS

7750: );
7751:
7752:
7753: CURSOR C_SOLD_TO_ACCOUNT_MANAGER IS
7754: SELECT 1 FROM DUAL WHERE EXISTS
7755: (
7756:
7757: select null
7758: from HZ_PARTIES P