DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on MTL_UOM_CLASS_CONVERSIONS

Line 5079: FROM MTL_UOM_CLASS_CONVERSIONS MOU, PO_LINE_LOCATIONS_GT POLL,

5075: p_sequence + ROWNUM,
5076: substr(g_shipmsg||g_delim||POLL.shipment_num||g_delim||l_textline||
5077: MTL1.uom_class||' , '||MTL2.uom_class,1,240),
5078: 'PO_SUB_UOM_CLASS_CONVERSION'
5079: FROM MTL_UOM_CLASS_CONVERSIONS MOU, PO_LINE_LOCATIONS_GT POLL,
5080: PO_LINES POL, MTL_UOM_CLASSES_TL MTL1,
5081: MTL_UOM_CLASSES_TL MTL2
5082: WHERE MOU.inventory_item_id = POL.item_id
5083: AND (NVL(MOU.disable_date, TRUNC(SYSDATE)) + 1) < TRUNC(SYSDATE)

Line 8853: FROM MTL_UOM_CLASS_CONVERSIONS MOU, PO_LINES_GT POL,

8849: p_sequence + ROWNUM,
8850: substr(g_linemsg||g_delim||POL.line_num||g_delim||l_textline||
8851: MTL1.uom_class||' , '||MTL2.uom_class,1,240),
8852: 'PO_SUB_UOM_CLASS_CONVERSION'
8853: FROM MTL_UOM_CLASS_CONVERSIONS MOU, PO_LINES_GT POL,
8854: MTL_UOM_CLASSES_TL MTL1, MTL_UOM_CLASSES_TL MTL2
8855: WHERE POL.item_id = MOU.inventory_item_id
8856: AND (nvl(MOU.disable_date, TRUNC(SYSDATE))+1) < TRUNC(SYSDATE)
8857: AND POL.po_header_id = p_document_id