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.

[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on DUAL

Line 5609: SELECT 1 FROM DUAL WHERE exists

5605: P_HEADER VARCHAR2(1);
5606:
5607:
5608: CURSOR C_FOB(p_lookup_code varchar2)is
5609: SELECT 1 FROM DUAL WHERE exists
5610: (
5611: SELECT meaning fob
5612: FROM ar_lookups
5613: WHERE lookup_type = 'FOB'

Line 5621: SELECT 1 FROM DUAL WHERE EXISTS

5617: AND lookup_code = p_lookup_code
5618: ) ;
5619:
5620: CURSOR C_SHIPMENT_PRIORITY_CODE(p_shipment_priority_code varchar2) IS
5621: SELECT 1 FROM DUAL WHERE EXISTS
5622: (
5623: SELECT meaning shipment_priority
5624: FROM oe_lookups
5625: WHERE lookup_type = 'SHIPMENT_PRIORITY'

Line 5632: SELECT 1 FROM DUAL WHERE exists

5628: AND lookup_code = p_shipment_priority_code
5629: );
5630:
5631: CURSOR C_SALESCHANNEL(p_lookup_code varchar2) is
5632: SELECT 1 FROM DUAL WHERE exists
5633: (
5634: SELECT lookup_code
5635: FROM fnd_lookup_values_vl
5636: WHERE lookup_type = 'SALES_CHANNEL'

Line 5646: SELECT 1 FROM DUAL WHERE exists

5642: );
5643:
5644:
5645: CURSOR C_QOTHDDET_CURRENCY_NOT_NULL(p_currency_code varchar2,p_price_list_id varchar2) is
5646: SELECT 1 FROM DUAL WHERE exists
5647: (
5648: SELECT d.currency_code currency_code
5649: FROM Fnd_currencies d
5650: ,qp_currency_details b

Line 5676: SELECT 1 FROM DUAL WHERE exists

5672: );
5673:
5674:
5675: CURSOR C_QOTHDDET_CURRENCY_NULL(p_currency_code varchar2) is
5676: SELECT 1 FROM DUAL WHERE exists
5677: (
5678: SELECT b.currency_code
5679: FROM fnd_currencies b
5680: WHERE b.currency_flag = 'Y'

Line 5688: SELECT 1 FROM DUAL WHERE exists

5684: );
5685:
5686: --New Cursor(s) start
5687: CURSOR C_PAYMENT_TYPE(p_lookup_code varchar2) is --Payment Type
5688: SELECT 1 FROM DUAL WHERE exists
5689: (
5690: SELECT Lookup_Code Payment_Type_Code
5691: from ASO_LOOKUPS
5692: WHERE LOOKUP_TYPE = 'ASO_PAYMENT_TYPE'

Line 5701: SELECT 1 FROM DUAL WHERE exists

5697: and lookup_code = p_lookup_code
5698: );
5699:
5700: CURSOR C_CREDIT_CARD_TYPE(p_credit_card_code varchar2) is --Credit Card Type
5701: SELECT 1 FROM DUAL WHERE exists
5702: (
5703: SELECT CARD_ISSUER_CODE credit_card_code
5704: FROM IBY_CREDITCARD_ISSUERS_V
5705: where CARD_ISSUER_CODE = p_credit_card_code

Line 5709: SELECT 1 FROM DUAL WHERE exists

5705: where CARD_ISSUER_CODE = p_credit_card_code
5706: );
5707:
5708: CURSOR C_DEMAND_CLASS(p_lookup_code varchar2) is --Demand Class
5709: SELECT 1 FROM DUAL WHERE exists
5710: (
5711: Select lookup_code Demand_Class_Code,
5712: meaning Demand_Class,
5713: description

Line 5724: SELECT 1 FROM DUAL WHERE exists

5720: And lookup_code = p_lookup_code
5721: );
5722:
5723: CURSOR C_REQUEST_DATE_TYPE(p_lookup_code varchar2) is --Request Date Type
5724: SELECT 1 FROM DUAL WHERE exists
5725: (
5726: Select lookup_code
5727: from oe_lookups
5728: where lookup_type='REQUEST_DATE_TYPE'

Line 5736: SELECT 1 FROM DUAL WHERE exists

5732: and trunc(nvl(end_date_active,sysdate))
5733: );
5734:
5735: CURSOR C_REQUEST_DATE(p_request_date date) is --Request Date(Confirm it)
5736: SELECT 1 FROM DUAL WHERE exists
5737: (
5738: select 1 from dual where trunc(p_request_date) >= trunc(sysdate)
5739: );
5740:

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

5734:
5735: CURSOR C_REQUEST_DATE(p_request_date date) is --Request Date(Confirm it)
5736: SELECT 1 FROM DUAL WHERE exists
5737: (
5738: select 1 from dual where trunc(p_request_date) >= trunc(sysdate)
5739: );
5740:
5741: CURSOR C_OPERATING_UNIT(p_org_id varchar2) is
5742: select DECODE(MO_GLOBAL.CHECK_ACCESS(p_org_id),'Y','Y','N',NULL,NULL) from dual ;

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

5738: select 1 from dual where trunc(p_request_date) >= trunc(sysdate)
5739: );
5740:
5741: CURSOR C_OPERATING_UNIT(p_org_id varchar2) is
5742: select DECODE(MO_GLOBAL.CHECK_ACCESS(p_org_id),'Y','Y','N',NULL,NULL) from dual ;
5743:
5744:
5745: CURSOR C_CHARGE_PERIODICITY_CODE(p_periodicity_code VARCHAR2,p_periodicity_profile VARCHAR2) is --CHARGE_PERIODICITY
5746: SELECT 1 FROM DUAL WHERE exists

Line 5746: SELECT 1 FROM DUAL WHERE exists

5742: select DECODE(MO_GLOBAL.CHECK_ACCESS(p_org_id),'Y','Y','N',NULL,NULL) from dual ;
5743:
5744:
5745: CURSOR C_CHARGE_PERIODICITY_CODE(p_periodicity_code VARCHAR2,p_periodicity_profile VARCHAR2) is --CHARGE_PERIODICITY
5746: SELECT 1 FROM DUAL WHERE exists
5747: (
5748: Select distinct uom_code
5749: From MTL_UNITS_OF_MEASURE_VL --Changed mtl_uom_conversions to MTL_UNITS_OF_MEASURE_VL 05/10/2005(Yogeshwar)
5750: Where uom_class=p_periodicity_profile

Line 5755: SELECT 1 FROM DUAL WHERE exists

5751: And uom_code=p_periodicity_code
5752: );
5753:
5754: CURSOR C_AUTOMATIC_PRICING(p_lookup_code varchar2) IS --Auotmatic Pricing
5755: SELECT 1 FROM DUAL WHERE exists
5756: (
5757: select lookup_code
5758: from aso_lookups
5759: where lookup_type='ASO_PRICE_TAX_COMPUTE_OPTION'

Line 5769: SELECT 1 FROM DUAL WHERE exists

5765: );
5766:
5767:
5768: CURSOR C_AUTOMATIC_TAX(p_lookup_code varchar2) IS --Auotmatic Tax
5769: SELECT 1 FROM DUAL WHERE exists
5770: (
5771: select lookup_code
5772: from aso_lookups
5773: where lookup_type='ASO_PRICE_TAX_COMPUTE_OPTION'

Line 5795: SELECT 1 FROM DUAL WHERE EXISTS

5791: ) is
5792:
5793:
5794: CURSOR C_VALIDATE_PHONE_CONTACT IS
5795: SELECT 1 FROM DUAL WHERE EXISTS
5796: (
5797: SELECT phone.contact_point_id
5798: FROM HZ_CONTACT_POINTS phone,
5799: HZ_PARTIES hp

Line 5811: SELECT 1 FROM DUAL WHERE EXISTS

5807: );
5808:
5809:
5810: CURSOR C_VALIDATE_PHONE_CUSTOMER IS -- when customer is specified and party_type is of type 'PERSON'
5811: SELECT 1 FROM DUAL WHERE EXISTS
5812: (
5813:
5814: SELECT phone.contact_point_id
5815: FROM HZ_CONTACT_POINTS phone,

Line 5901: SELECT 1 FROM DUAL WHERE EXISTS

5897: -- p_flag possible values END-
5898: -- p_header possible values Y and N
5899:
5900: CURSOR C_CUST_PARTY IS
5901: SELECT 1 FROM DUAL WHERE EXISTS
5902: (
5903: SELECT hp.party_name --(Base Query)
5904: FROM HZ_PARTIES HP
5905: WHERE hp.party_type in ('PERSON','ORGANIZATION')

Line 5913: SELECT 1 FROM DUAL WHERE EXISTS

5909:
5910:
5911: -- When ASN_CUST_ACCESS = T and manager_flag = 'Y'
5912: CURSOR C_CUST_PARTY_MANAGER IS
5913: SELECT 1 FROM DUAL WHERE EXISTS
5914: (
5915: select null
5916: from HZ_PARTIES P
5917: where P.status = 'A'

Line 5960: SELECT 1 FROM DUAL WHERE EXISTS

5956:
5957: -- When ASN_CUST_ACCESS = T and manager_flag = 'N'
5958:
5959: CURSOR C_CUST_PARTY_NO_MANAGER IS
5960: SELECT 1 FROM DUAL WHERE EXISTS
5961: (
5962:
5963: select P.party_name
5964: from HZ_PARTIES P

Line 5979: select 1 from dual where exists

5975:
5976: );
5977:
5978: Cursor C_Mgr_Check Is --to check the manager flag
5979: select 1 from dual where exists
5980: (
5981: SELECT MGR.group_id
5982: FROM jtf_rs_rep_managers MGR ,
5983: jtf_rs_group_usages U

Line 6207: SELECT 1 FROM DUAL WHERE EXISTS

6203: -- QOTHDDET_MAIN.sold_to_cust_party_id --> p_quote_header_rec.cust_party_id
6204:
6205: --CURSOR C_BILL_SHIP_CONTACT_NAME IS
6206: CURSOR C_CONTACT_NAME IS
6207: SELECT 1 FROM DUAL WHERE EXISTS
6208: (
6209: SELECT hp_contact.party_name
6210: FROM HZ_PARTIES hp_contact,
6211: HZ_RELATIONSHIPS hp_rltn

Line 6362: select 1 from DUAL where exists

6358: -- p_flag possible values : BILL or SHIP
6359: -- p_header possible values : Y or N
6360:
6361: Cursor C_Mgr_Check Is --to check the manager flag
6362: select 1 from DUAL where exists
6363: (
6364: SELECT MGR.group_id
6365: FROM jtf_rs_rep_managers MGR ,
6366: jtf_rs_group_usages U

Line 6379: SELECT 1 FROM DUAL WHERE EXISTS

6375:
6376: --CURSOR C_INVOICE_TO_CUST_PARTY_NAME_FLD IS
6377: CURSOR C_INVOICE_TO_CUSTOMER IS
6378: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6379: SELECT 1 FROM DUAL WHERE EXISTS
6380: (
6381: SELECT hp.party_id --Removed HZ_CUST_ACCOUNTS ca
6382: FROM HZ_PARTIES hp
6383: WHERE hp.party_type in ('PERSON','ORGANIZATION')

Line 6403: SELECT 1 FROM DUAL WHERE EXISTS

6399:
6400: CURSOR C_SHIP_TO_CUSTOMER IS
6401: --CURSOR C_SHIP_TO_CUST_PARTY_NAME_FLD IS
6402: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6403: SELECT 1 FROM DUAL WHERE EXISTS
6404: (
6405: SELECT hp.party_id
6406: FROM HZ_PARTIES hp
6407: WHERE hp.party_id = p_cust_party_id

Line 6426: SELECT 1 FROM DUAL WHERE EXISTS

6422:
6423: -- When ASO_ENFORCE_ACCOUNT_RELATIONSHIPS = 'N' and ASN_CUST_ACCESS = T
6424: --CURSOR C_CUST_PARTY_NAME1 IS
6425: CURSOR C_CUSTOMER IS
6426: SELECT 1 FROM DUAL WHERE EXISTS
6427: (
6428: SELECT hp.party_id
6429: FROM HZ_PARTIES hp
6430: WHERE hp.party_type in ('PERSON','ORGANIZATION')

Line 6438: SELECT 1 FROM DUAL WHERE EXISTS

6434:
6435: -- When ASO_ENFORCE_ACCOUNT_RELATIONSHIPS = 'N' and ASN_CUST_ACCESS = T and manager_flag = 'Y'
6436: --CURSOR C_CUST_PARTY_NAME2 IS
6437: CURSOR C_CUSTOMER_MANAGER IS
6438: SELECT 1 FROM DUAL WHERE EXISTS
6439: (
6440: select P.party_id
6441: from HZ_PARTIES P
6442: where P.status = 'A'

Line 6481: SELECT 1 FROM DUAL WHERE EXISTS

6477:
6478: -- When ASO_ENFORCE_ACCOUNT_RELATIONSHIPS = 'N' and ASN_CUST_ACCESS = T and manager_flag = 'N'
6479:
6480: CURSOR C_CUSTOMER_NO_MANAGER IS
6481: SELECT 1 FROM DUAL WHERE EXISTS
6482: (
6483:
6484: select P.status
6485: from HZ_PARTIES P

Line 6805: select 1 from dual where exists

6801: -- p_flag possible values : BILL or SHIP
6802: -- p_header possible values : Y or N
6803:
6804: Cursor C_Mgr_Check Is --to check the manager flag
6805: select 1 from dual where exists
6806: (
6807: SELECT MGR.group_id
6808: FROM jtf_rs_rep_managers MGR ,
6809: jtf_rs_group_usages U

Line 6821: --SELECT 1 FROM DUAL WHERE EXISTS

6817: );
6818:
6819: CURSOR C_INVOICE_TO_CUST_ACCOUNT IS
6820: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6821: --SELECT 1 FROM DUAL WHERE EXISTS
6822: --(
6823: -- SELECT ca.account_number
6824: -- FROM HZ_PARTIES hp,
6825: -- HZ_CUST_ACCOUNTS ca,

Line 6842: SELECT 1 FROM DUAL WHERE EXISTS

6838: -- AND trunc(nvl(ca.account_activation_date,sysdate)) <= trunc(sysdate)
6839: -- AND trunc(nvl(ca.account_termination_date,sysdate)) >= trunc(sysdate)
6840: -- AND car.status = 'A'
6841: --) ;
6842: SELECT 1 FROM DUAL WHERE EXISTS
6843: (
6844: SELECT ca.account_number
6845: FROM HZ_PARTIES hp,
6846: HZ_CUST_ACCOUNTS ca,

Line 6880: --SELECT 1 FROM DUAL WHERE EXISTS

6876:
6877:
6878: CURSOR C_SHIP_TO_CUST_ACCOUNT IS
6879: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6880: --SELECT 1 FROM DUAL WHERE EXISTS
6881: --(
6882: -- SELECT ca.account_number
6883: -- FROM HZ_PARTIES hp,
6884: -- HZ_CUST_ACCOUNTS ca,

Line 6933: SELECT 1 FROM DUAL WHERE EXISTS

6929:
6930:
6931: -- When ASO_ENFORCE_ACCOUNT_RELATIONSHIPS = 'N' and ASN_CUST_ACCESS = F
6932: CURSOR C_CUST_ACCOUNT IS
6933: SELECT 1 FROM DUAL WHERE EXISTS
6934: (
6935: SELECT ca.account_number
6936: FROM HZ_PARTIES hp,
6937: HZ_CUST_ACCOUNTS ca

Line 6951: SELECT 1 FROM DUAL WHERE EXISTS

6947:
6948: -- When ASO_ENFORCE_ACCOUNT_RELATIONSHIPS = 'N' and ASN_CUST_ACCESS = T and manager_flag = 'Y'
6949:
6950: CURSOR C_CUST_ACCOUNT_MANAGER IS
6951: SELECT 1 FROM DUAL WHERE EXISTS
6952: (
6953: select null
6954: from HZ_PARTIES P
6955: ,HZ_CUST_ACCOUNTS CA

Line 7002: SELECT 1 FROM DUAL WHERE EXISTS

6998:
6999: -- When ASO_ENFORCE_ACCOUNT_RELATIONSHIPS = 'N' and ASN_CUST_ACCESS = T and manager_flag = 'N'
7000:
7001: CURSOR C_CUST_ACCOUNT_NO_MANAGER IS
7002: SELECT 1 FROM DUAL WHERE EXISTS
7003: (
7004:
7005: select CA.account_number
7006: from HZ_PARTIES HP ,

Line 7314: SELECT 1 FROM DUAL WHERE EXISTS

7310:
7311: l_data_exists VARCHAR2(10) ;
7312:
7313: CURSOR C_PARTY_ADDRESS IS
7314: SELECT 1 FROM DUAL WHERE EXISTS
7315: (
7316: SELECT site.party_site_id
7317: FROM HZ_PARTIES hp,
7318: HZ_PARTY_SITES site

Line 7328: SELECT 1 FROM DUAL WHERE EXISTS

7324: );
7325:
7326: --CURSOR C_PARTY_ADDRESS2 IS
7327: CURSOR C_CUST_PARTY_ADDRESS_NOT_NULL IS
7328: SELECT 1 FROM DUAL WHERE EXISTS
7329: (
7330: SELECT site.party_site_id
7331: FROM HZ_PARTIES hp,
7332: HZ_PARTY_SITES site

Line 7342: SELECT 1 FROM DUAL WHERE EXISTS

7338: );
7339:
7340: --CURSOR C_PARTY_ADDRESS3 IS
7341: CURSOR C_CUSTOMER_ADDRESS_NOT_NULL IS
7342: SELECT 1 FROM DUAL WHERE EXISTS
7343: (
7344:
7345: SELECT site.party_site_id
7346: FROM HZ_PARTIES hp,

Line 7684: select 1 from dual where exists

7680: --:PARAMETER.user_resource_id-->p_resource_id-->p_quote_header_rec.resource_id
7681:
7682:
7683: Cursor C_Mgr_Check Is --to check the manager flag
7684: select 1 from dual where exists
7685: (
7686: SELECT MGR.group_id
7687: FROM jtf_rs_rep_managers MGR ,
7688: jtf_rs_group_usages U

Line 7700: SELECT 1 FROM DUAL WHERE EXISTS

7696: );
7697:
7698:
7699: CURSOR C_SOLD_TO_ACCOUNT IS
7700: SELECT 1 FROM DUAL WHERE EXISTS
7701: (
7702: SELECT ca.account_number
7703: FROM HZ_PARTIES HP,
7704: HZ_CUST_ACCOUNTS CA

Line 7715: SELECT 1 FROM DUAL WHERE EXISTS

7711: AND ca.cust_account_id = p_cust_acct_id
7712: );
7713:
7714: CURSOR C_SOLD_TO_ACCOUNT_NO_MANAGER IS
7715: SELECT 1 FROM DUAL WHERE EXISTS
7716: (
7717: select ca.account_number
7718: from HZ_PARTIES P
7719: , HZ_CUST_ACCOUNTS CA

Line 7738: SELECT 1 FROM DUAL WHERE EXISTS

7734: );
7735:
7736:
7737: CURSOR C_SOLD_TO_ACCOUNT_MANAGER IS
7738: SELECT 1 FROM DUAL WHERE EXISTS
7739: (
7740:
7741: select null
7742: from HZ_PARTIES P