DBA Data[Home] [Help]

APPS.DPP_COVEREDINVENTORY_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 65: FROM mtl_onhand_quantities_detail moqd,

61: --BETWEEN p_effective_start_date and p_effective_end_date)
62: then moqd.transaction_quantity else 0 end) covered_qty,
63: sum(moqd.transaction_quantity) onhand_qty,
64: moqd.transaction_uom_code
65: FROM mtl_onhand_quantities_detail moqd,
66: org_organization_definitions ood,
67: mtl_parameters mp
68: WHERE moqd.organization_id = ood.organization_id
69: AND moqd.inventory_item_id = p_inventory_item_id

Line 90: mtl_onhand_quantities_detail moqd,

86: SUM(moqd.transaction_quantity) sum,
87: ood.organization_name warehouse,
88: ood.organization_id warehouse_id
89: FROM
90: mtl_onhand_quantities_detail moqd,
91: org_organization_definitions ood,
92: mtl_parameters mp
93: WHERE moqd.organization_id = ood.organization_id
94: AND moqd.inventory_item_id = p_inventory_item_id

Line 113: mtl_onhand_quantities_detail moqd,

109: SELECT
110: (NVL(moqd.orig_date_received,moqd.date_received)) date_received,
111: SUM(moqd.transaction_quantity) sum
112: FROM
113: mtl_onhand_quantities_detail moqd,
114: org_organization_definitions ood,
115: mtl_parameters mp
116: WHERE
117: moqd.organization_id = ood.organization_id AND