APPS.GMD_COA_DATA_NEW dependencies on GMD_SAMPLES

Line 855: CURSOR get_cust_rslt_info (c_orgn_code gmd_samples.orgn_code%TYPE,

851: tbl_dtl IN OUT NOCOPY t_coa_detail_tbl) IS
852:
853: /* BEGIN BUG#1810652 James Bernard */
854: /* Added 'c_item_id is NULL or' in the where clause */
855: CURSOR get_cust_rslt_info (c_orgn_code gmd_samples.orgn_code%TYPE,
856: c_item_id ic_item_mst.item_id%TYPE,
857: c_lot_id ic_lots_mst.lot_id%TYPE,
858: c_cust_id op_cust_mst.cust_id%TYPE) IS
859: select gr.result_id qc_result_id,

Line 869: from gmd_samples gs,

865: specification,
866: gst.test_uom uom,
867: gst.text_code spec_text_code,
868: gr.text_code rslt_text_code
869: from gmd_samples gs,
870: gmd_results gr,
871: gmd_qc_tests_b gt,
872: gmd_spec_results gsr,
873: gmd_spec_tests_b gst ,

Line 907: CURSOR get_item_rslt_info (c_orgn_code gmd_samples.orgn_code%TYPE,

903:
904: /* use the next cursor if no rows returned from get_cust_rslt_info */
905: /* BEGIN BUG#1810652 James Bernard */
906: /* Added 'c_item_id is NULL or' and 'c_lot_id is NULL or' in the where clause */
907: CURSOR get_item_rslt_info (c_orgn_code gmd_samples.orgn_code%TYPE,
908: c_item_id ic_item_mst.item_id%TYPE,
909: c_lot_id ic_lots_mst.lot_id%TYPE) IS
910: select gr.result_id qc_result_id,
911: gst.spec_id qc_spec_id,

Line 920: from gmd_samples gs,

916: specification,
917: gst.test_uom uom,
918: gst.text_code spec_text_code,
919: gr.text_code rslt_text_code
920: from gmd_samples gs,
921: gmd_results gr,
922: gmd_qc_tests_b gt,
923: gmd_spec_results gsr,
924: gmd_spec_tests_b gst ,

Line 1489: gmd_samples gs,

1485: gs.item_id,
1486: gs.whse_code,
1487: gs.lot_id
1488: from
1489: gmd_samples gs,
1490: gmd_results gr,
1491: gmd_spec_results gsr,
1492: gmd_sampling_events gse,
1493: gmd_event_spec_disp ges,

Line 1527: gmd_samples gs,

1523: gs.item_id,
1524: gs.whse_code,
1525: gs.lot_id
1526: from
1527: gmd_samples gs,
1528: gmd_results gr,
1529: gmd_spec_results gsr,
1530: gmd_sampling_events gse,
1531: gmd_event_spec_disp ges,