DBA Data[Home] [Help]

APPS.JAI_PO_HOOK_PKG dependencies on JAI_RCV_TRANSACTIONS

Line 725: UPDATE JAI_RCV_TRANSACTIONS

721: ELSIF p_process_Action = 'N' THEN
722: lv_process_flag := 'P';
723: END IF;
724:
725: UPDATE JAI_RCV_TRANSACTIONS
726: SET process_status = lv_process_flag,
727: cenvat_rg_status = lv_process_flag,
728: cenvat_rg_message = NULL,
729: process_vat_status = lv_process_flag

Line 1862: FROM jai_rcv_transactions

1858: 'CORRECT',
1859: Decode(parent_transaction_type,'RECEIVE',quantity,
1860: 'RETURN TO VENDOR',-1*quantity,0),
1861: 0))
1862: FROM jai_rcv_transactions
1863: WHERE shipment_header_id = p_shid
1864: AND shipment_line_id = p_slid;
1865:
1866: CURSOR c_rec_qty (p_shid NUMBER, p_slid NUMBER) IS

Line 1868: FROM jai_rcv_transactions

1864: AND shipment_line_id = p_slid;
1865:
1866: CURSOR c_rec_qty (p_shid NUMBER, p_slid NUMBER) IS
1867: SELECT Sum(quantity)
1868: FROM jai_rcv_transactions
1869: WHERE shipment_header_id=p_shid
1870: AND shipment_line_id=p_slid
1871: AND transaction_type='RECEIVE';
1872: