DBA Data[Home] [Help]

APPS.DPP_COVEREDINVENTORY_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 66: org_organization_definitions ood,

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
70: AND mp.organization_id = ood.organization_id

Line 91: org_organization_definitions ood,

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
95: AND ood.operating_unit = p_org_id

Line 114: org_organization_definitions ood,

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
118: moqd.inventory_item_id = p_inventory_item_id AND