[Home] [Help]
45: WHERE inventory_item_id = p_inventory_item_id
46: AND organization_id = p_organization_id;
47:
48: /* Cursor to select party Type */
49: CURSOR c_party ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE )
50: IS
51: SELECT PARTY_TYPE
52: FROM HZ_PARTIES
53: WHERE party_id = b_customer_id;
64:
65: /* Bug 3917132
66: Cursor to get the Bill to Address */
67: CURSOR c_bill_to_site_id
68: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
69: ) IS
70: SELECT use.party_site_use_id FROM
71: hz_party_sites site, hz_party_site_uses use
72: WHERE site.party_site_id = use.party_site_id
80:
81: /* Bug 3917132
82: Cursor to get the Ship to Address */
83: CURSOR c_ship_to_site_id
84: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
85: ) IS
86: SELECT use.party_site_use_id FROM
87: hz_party_sites site, hz_party_site_uses use
88: WHERE site.party_site_id = use.party_site_id
94: AND trunc(SYSDATE) BETWEEN TRUNC (NVL(use.begin_date, SYSDATE))
95: AND (NVL(use.end_date, SYSDATE));
96:
97: /* Cursor to get the customer account id */
98: CURSOR c_customer_account( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE)
99: IS
100: SELECT custa.cust_account_id
101: FROM hz_cust_accounts custa
102: WHERE custa.status = 'A'
403: )
404: is
405: select incident_id
406: , object_version_number
407: from cs_incidents
408: where incident_id = b_incident_id;
409:
410: r_ovn c_ovn%rowtype;
411:
415: )
416: is
417: SELECT LAST_UPDATE_DATE,
418: LAST_UPDATED_BY
419: from CS_INCIDENTS_ALL_B
420: where incident_id = b_incident_id;
421:
422: --115.10
423: CURSOR l_install_site_csr (p_customer_product_id IN number)
943: l_user_name in varchar2,
944: l_sequence in number)
945: IS
946: SELECT b.last_updated_by
947: FROM CS_INCIDENTS_ALL_B b,
948: CSM_INCIDENTS_ALL_INQ a
949: WHERE a.clid$$cs = l_user_name
950: AND tranid$$ = l_tran_id
951: AND seqno$$ = l_sequence