DBA Data[Home] [Help]

APPS.GMICCAL dependencies on IC_TRAN_CMP

Line 507: FROM ic_tran_cmp

503: SELECT item_id, lot_id, whse_code,
504: location, doc_type, line_type,
505: reason_code, trans_date, trans_id,
506: trans_qty, trans_qty2
507: FROM ic_tran_cmp
508: WHERE whse_code = UPPER(pwhse_code)
509: AND trans_date >= pprd_start_date
510: AND creation_date <= plog_end_date
511: AND trans_qty <> 0