APPS.GML_BATCH_OM_RES_PVT dependencies on GML_BATCH_SO_ALLOC_HISTORY

Line 598: Update gml_batch_so_alloc_history

594: END IF;
595: END IF;
596: IF nvl(p_batch_line_rec.release_type,0) = 20 THEN
597: /* IF regenerate, set the current history to delete */
598: Update gml_batch_so_alloc_history
599: set delete_mark = 1
600: Where batch_res_id = res_rec.batch_res_id
601: And batch_trans_id = l_gme_trans_row.trans_id
602: And failure_reason is not null;

Line 671: , gml_batch_so_alloc_history his

667:
668: Cursor find_nonstgd_alloc_for_trans (P_batch_trans_id IN NUMBER) IS
669: Select ic.trans_id
670: From ic_tran_pnd ic
671: , gml_batch_so_alloc_history his
672: Where his.batch_trans_id = p_batch_trans_id
673: and his.trans_id = ic.trans_id
674: and ic.line_id = his.line_id
675: and ic.staged_ind = 0

Line 754: , gml_batch_so_alloc_history his

750:
751: Cursor find_nonstgd_alloc_for_batch (P_batch_id IN NUMBER) IS
752: Select ic.trans_id
753: From ic_tran_pnd ic
754: , gml_batch_so_alloc_history his
755: Where his.batch_id = p_batch_id
756: and his.trans_id = ic.trans_id
757: and ic.line_id = his.line_id
758: and ic.staged_ind = 0

Line 818: , gml_batch_so_alloc_history his

814:
815: Cursor find_nonstgd_alloc_for_batch (P_batch_line_id IN NUMBER) IS
816: Select ic.trans_id
817: From ic_tran_pnd ic
818: , gml_batch_so_alloc_history his
819: Where his.batch_line_id = p_batch_line_id
820: and his.trans_id = ic.trans_id
821: and ic.line_id = his.line_id
822: and ic.staged_ind = 0

Line 1024: , gml_batch_so_alloc_history his

1020:
1021: Cursor so_line_id_for_batch_trans (p_batch_trans_id IN NUMBER) IS
1022: Select distinct ictran.line_id
1023: From ic_tran_pnd ictran
1024: , gml_batch_so_alloc_history his
1025: Where his.batch_trans_id = p_batch_trans_id
1026: and his.trans_id = ictran.trans_id
1027: and ictran.doc_type = 'OMSO'
1028: and ictran.delete_mark = 0

Line 1037: FROM gml_batch_so_alloc_history

1033: Cursor get_batch_id_for_trans (p_batch_trans_id IN NUMBER) IS
1034: SELECT batch_id
1035: ,batch_type
1036: ,batch_line_id
1037: FROM gml_batch_so_alloc_history
1038: WHERE batch_trans_id = p_batch_trans_id;
1039:
1040:
1041: CURSOR CSR_for_so_line(p_so_line_id IN NUMBER) IS

Line 1049: , gml_batch_so_alloc_history his

1045:
1046: Cursor find_nonstgd_alloc_for_trans (P_batch_trans_id IN NUMBER) IS
1047: Select count(*)
1048: From ic_tran_pnd ic
1049: , gml_batch_so_alloc_history his
1050: Where his.batch_trans_id = p_batch_trans_id
1051: and his.trans_id = ic.trans_id
1052: and ic.line_id = his.line_id
1053: and ic.staged_ind = 0

Line 1061: , gml_batch_so_alloc_history his

1057:
1058: Cursor find_staged_alloc_for_trans (P_batch_trans_id IN NUMBER) IS
1059: Select count(*)
1060: From ic_tran_pnd ic
1061: , gml_batch_so_alloc_history his
1062: Where his.batch_trans_id = p_batch_trans_id
1063: and his.trans_id = ic.trans_id
1064: and ic.line_id = his.line_id
1065: and ic.staged_ind = 1

Line 1390: update gml_batch_so_alloc_history

1386: ) ;
1387:
1388: IF x_return_status = fnd_api.g_ret_sts_success Then
1389: /* delete the history record because new history records are created */
1390: update gml_batch_so_alloc_history
1391: set delete_mark = 1
1392: Where alloc_rec_id = p_alloc_history_rec.alloc_rec_id;
1393:
1394: /* NC Bug#3470056 Call pick confirm if the flag is set */

Line 1728: From gml_batch_so_alloc_history

1724: From ic_tran_pnd
1725: Where delete_mark = 0
1726: and trans_id in
1727: (Select trans_id
1728: From gml_batch_so_alloc_history
1729: Where batch_trans_id = p_batch_trans_id
1730: and delete_mark = 0
1731: )
1732: ;

Line 1742: From gml_batch_so_alloc_history

1738: Where wdd.delivery_detail_id = ictran.line_detail_id
1739: and ictran.delete_mark = 0
1740: and ictran.trans_id in
1741: (Select trans_id
1742: From gml_batch_so_alloc_history
1743: Where batch_line_id = p_batch_line_id
1744: and delete_mark = 0
1745: )
1746: ;