DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on MTL_UOM_CLASS_CONVERSIONS

Line 3242: FROM MTL_UOM_CLASS_CONVERSIONS MOU, PO_LINE_LOCATIONS_GT POLL,

3238: p_sequence + ROWNUM,
3239: substr(g_shipmsg||g_delim||POLL.shipment_num||g_delim||l_textline||
3240: MTL1.uom_class||' , '||MTL2.uom_class,1,240),
3241: 'PO_SUB_UOM_CLASS_CONVERSION'
3242: FROM MTL_UOM_CLASS_CONVERSIONS MOU, PO_LINE_LOCATIONS_GT POLL,
3243: PO_LINES POL, MTL_UOM_CLASSES_TL MTL1,
3244: MTL_UOM_CLASSES_TL MTL2
3245: WHERE MOU.inventory_item_id = POL.item_id
3246: AND (NVL(MOU.disable_date, TRUNC(SYSDATE)) + 1) < TRUNC(SYSDATE)

Line 6206: FROM MTL_UOM_CLASS_CONVERSIONS MOU, PO_LINES_GT POL,

6202: p_sequence + ROWNUM,
6203: substr(g_linemsg||g_delim||POL.line_num||g_delim||l_textline||
6204: MTL1.uom_class||' , '||MTL2.uom_class,1,240),
6205: 'PO_SUB_UOM_CLASS_CONVERSION'
6206: FROM MTL_UOM_CLASS_CONVERSIONS MOU, PO_LINES_GT POL,
6207: MTL_UOM_CLASSES_TL MTL1, MTL_UOM_CLASSES_TL MTL2
6208: WHERE POL.item_id = MOU.inventory_item_id
6209: AND (nvl(MOU.disable_date, TRUNC(SYSDATE))+1) < TRUNC(SYSDATE)
6210: AND POL.po_header_id = p_document_id