APPS.OZF_OFFER_PVT dependencies on OZF_SD_CUSTOMER_DETAILS

Line 11650: FROM ozf_sd_customer_details

11646: SELECT request_customer_id,party_id,
11647: cust_account_id,site_use_id,
11648: cust_usage_code,end_customer_flag,
11649: cust_usage_value
11650: FROM ozf_sd_customer_details
11651: WHERE request_header_id = p_sdr_header_id
11652: AND end_customer_flag='N'
11653: AND NVL(operation_flag, 'I') = 'I';
11654:

Line 11660: FROM ozf_sd_customer_details

11656: SELECT request_customer_id,party_id,
11657: cust_account_id,site_use_id,
11658: cust_usage_code,end_customer_flag,
11659: cust_usage_value
11660: FROM ozf_sd_customer_details
11661: WHERE request_header_id = p_sdr_header_id
11662: AND end_customer_flag='Y'
11663: AND NVL(operation_flag, 'I') = 'I';
11664:

Line 11667: FROM ozf_sd_customer_details

11663: AND NVL(operation_flag, 'I') = 'I';
11664:
11665: CURSOR cur_get_end_cust_count IS
11666: SELECT count(request_customer_id)
11667: FROM ozf_sd_customer_details
11668: WHERE request_header_id = p_sdr_header_id
11669: AND end_customer_flag = 'Y';
11670:
11671:

Line 11730: FROM ozf_sd_customer_details

11726:
11727: --Bug 13981597 - cursor to get count for delete operation (either all end customers to be deleted or some of them)
11728: CURSOR cur_end_cust_operation_count IS
11729: SELECT count(request_customer_id)
11730: FROM ozf_sd_customer_details
11731: WHERE request_header_id = p_sdr_header_id
11732: AND end_customer_flag = 'Y'
11733: AND NVL(operation_flag, 'I') = 'I';
11734:

Line 11752: FROM ozf_sd_customer_details

11748: SELECT request_customer_id,party_id,
11749: cust_account_id,site_use_id,
11750: cust_usage_code,end_customer_flag,
11751: cust_usage_value, operation_flag
11752: FROM ozf_sd_customer_details
11753: WHERE request_header_id = p_sdr_header_id
11754: AND end_customer_flag = 'N'
11755: AND operation_flag IS NOT NULL;
11756:

Line 12022: UPDATE ozf_sd_customer_details

12018: END LOOP; --End of cur_get_qual_lines_no_end_cust loop
12019: END IF; --IF for any end customer exists
12020:
12021: --After processing records with operation_flag='I' make operation_flag of those records as NULL
12022: UPDATE ozf_sd_customer_details
12023: SET operation_flag = NULL
12024: WHERE request_header_id = p_sdr_header_id
12025: AND operation_flag = 'I';
12026:

Line 12027: -- Delete all the records from table ozf_sd_customer_details with operation_flag value as D

12023: SET operation_flag = NULL
12024: WHERE request_header_id = p_sdr_header_id
12025: AND operation_flag = 'I';
12026:
12027: -- Delete all the records from table ozf_sd_customer_details with operation_flag value as D
12028: DELETE FROM ozf_sd_customer_details
12029: WHERE request_header_id = p_sdr_header_id
12030: AND operation_flag = 'D';
12031:

Line 12028: DELETE FROM ozf_sd_customer_details

12024: WHERE request_header_id = p_sdr_header_id
12025: AND operation_flag = 'I';
12026:
12027: -- Delete all the records from table ozf_sd_customer_details with operation_flag value as D
12028: DELETE FROM ozf_sd_customer_details
12029: WHERE request_header_id = p_sdr_header_id
12030: AND operation_flag = 'D';
12031:
12032: OPEN cur_get_internal_order_number;