[Home] [Help]
273: CURSOR get_cust_rslt_info (c_orgn_code gmd_samples.orgn_code%TYPE,
274: c_item_id ic_item_mst.item_id%TYPE,
275: c_lot_id ic_lots_mst.lot_id%TYPE,
276: c_lot_no ic_lots_mst.lot_no%TYPE,
277: c_cust_id hz_cust_accounts.cust_account_id%TYPE) IS
278: select gr.result_id qc_result_id,
279: gst.spec_id qc_spec_id,
280: gt.test_code assay_code,
281: gr.result_date result_date,
383: /*END BUG#1810652 */
384:
385:
386: CURSOR get_cust_spec (c_item_id ic_item_mst.item_id%TYPE,
387: c_cust_id hz_cust_accounts.cust_account_id%TYPE,
388: c_orgn_code gmd_customer_spec_vrs.ORGN_CODE%TYPE,
389: c_assay_code gmd_qc_tests_b.TEST_CODE%TYPE)
390: IS
391: select gsb.spec_id qc_spec_id,
406: and gcs.orgn_code = c_orgn_code
407: and gsb.delete_mark= 0;
408:
409: CURSOR get_global_cust_spec (c_item_id ic_item_mst.item_id%TYPE,
410: c_cust_id hz_cust_accounts.cust_account_id%TYPE,
411: c_assay_code gmd_qc_tests_b.TEST_CODE%TYPE)
412: IS
413: select gsb.spec_id qc_spec_id,
414: decode(gst.target_value_char, null, to_char(gst.target_value_num),gst.target_value_char)
837: wsh_delivery_assignments wda,
838: mtl_parameters ship_from_org,
839: mtl_system_items msi,
840: ic_item_mst ic,
841: hz_cust_accounts c,
842: hz_cust_site_uses_all s,
843: hz_cust_acct_sites_all a,
844: hz_parties pr
845: where h.header_id = l.header_id
937: WHERE item_id = c_item_id
938: and delete_mark = 0
939: ;*/
940:
941: /*CURSOR get_cust_info (c_cust_id hz_cust_accounts.cust_account_id%TYPE) IS
942: SELECT
943: custsort_no cust_no,
944: cust_name cust_name
945: from op_cust_mst
951: A.CUST_ACCT_SITE_ID cust_id,
952: C.ACCOUNT_NUMBER cust_no,
953: PR.PARTY_NAME cust_name
954: from
955: HZ_CUST_ACCOUNTS C,
956: HZ_CUST_SITE_USES_ALL S,
957: HZ_CUST_ACCT_SITES_ALL A,
958: HZ_PARTIES PR
959: where C.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID