DBA Data[Home] [Help]

APPS.FLM_EKB_SUMMARY_UTIL dependencies on MTL_TXN_REQUEST_LINES

Line 40: mtl_txn_request_lines l

36: ELSIF p_doc_type = 4 THEN /*Move Order*/
37: SELECT h.request_number
38: INTO l_doc_num
39: FROM mtl_txn_request_headers h,
40: mtl_txn_request_lines l
41: WHERE l.line_id = p_doc_detail_id
42: AND h.header_id = l.header_id;
43:
44: ELSE /* Wip Discrete Job, Rep Schedule, Flow Schedule, Lot job */

Line 90: mtl_txn_request_lines l

86: ELSIF p_doc_type = 4 THEN /*Move Order*/
87: SELECT h.creation_date
88: INTO l_doc_creation_date
89: FROM mtl_txn_request_headers h,
90: mtl_txn_request_lines l
91: WHERE l.line_id = p_doc_detail_id
92: AND h.header_id = l.header_id;
93:
94: ELSE /* Wip Discrete Job, Rep Schedule, Flow Schedule, Lot job */