DBA Data[Home] [Help]

APPS.PO_KANBAN_SV dependencies on PO_REQUISITION_HEADERS

Line 37: FROM PO_REQUISITION_HEADERS prh,

33:
34: -- Define cursor for getting PO Kanban Card ID
35: CURSOR Kanban_req_line IS
36: SELECT prl.REQUISITION_LINE_ID, prl.KANBAN_CARD_ID
37: FROM PO_REQUISITION_HEADERS prh,
38: PO_REQUISITION_LINES prl
39: WHERE prh.REQUISITION_HEADER_ID = p_document_id
40: AND prh.REQUISITION_HEADER_ID = prl.REQUISITION_HEADER_ID
41: AND prh.TYPE_LOOKUP_CODE = 'INTERNAL'