DBA Data[Home] [Help]

APPS.EAM_MATERIAL_ALLOCQTY_PKG dependencies on MTL_TXN_REQUEST_LINES

Line 21: from MTL_TXN_REQUEST_LINES mtrl,MTL_TXN_REQUEST_HEADERS mtrh

17:
18: begin
19: select sum(nvl(mtrl.quantity_detailed,0) - nvl(mtrl.quantity_delivered,0))
20: into l_quantity_allocated
21: from MTL_TXN_REQUEST_LINES mtrl,MTL_TXN_REQUEST_HEADERS mtrh
22: where
23: mtrl.TXN_SOURCE_ID = p_wip_entity_id and
24: mtrl.TXN_SOURCE_LINE_ID = p_operation_seq_num and
25: mtrl.organization_id = p_organization_id and

Line 62: from MTL_TXN_REQUEST_LINES mtrl,MTL_TXN_REQUEST_HEADERS mtrh

58:
59: begin
60: select sum(nvl(mtrl.quantity_detailed,0) - nvl(mtrl.quantity_delivered,0))
61: into l_quantity_allocated
62: from MTL_TXN_REQUEST_LINES mtrl,MTL_TXN_REQUEST_HEADERS mtrh
63: where
64: mtrl.TXN_SOURCE_ID = p_wip_entity_id and
65: mtrl.TXN_SOURCE_LINE_ID = p_operation_seq_num and
66: mtrl.organization_id = p_organization_id and