DBA Data[Home] [Help]

APPS.GMI_PICK_WAVE_CONFIRM_PVT dependencies on IC_TXN_REQUEST_LINES

Line 104: FROM IC_TXN_REQUEST_LINES

100: cursor get_qty IS
101: SELECT quantity,
102: quantity_detailed,
103: line_status
104: FROM IC_TXN_REQUEST_LINES
105: WHERE ship_set_id = p_ship_set_id
106: AND LINE_STATUS = 7;
107:
108:

Line 1721: FROM ic_txn_request_lines

1717: l_avail_req_qty2 NUMBER;
1718:
1719: CURSOR c_txn_source IS
1720: SELECT txn_source_line_id
1721: FROM ic_txn_request_lines
1722: WHERE line_id = p_line_id;
1723:
1724: CURSOR c_source_line IS
1725: SELECT source_line_id