DBA Data[Home] [Help]

APPS.CSM_MULTI_MOBQRY_PKG dependencies on CSM_REQ_LINE_DETAILS_ACC

Line 580: FOR rec IN (SELECT USER_ID FROM CSP_REQ_LINE_DETAILS rld ,CSM_REQ_LINE_DETAILS_ACC acc

576: CSM_SERIAL_NUMBERS_EVENT_PKG.RECEIVED_MTL_SERIAL_NUM(r_part_line.destination_organization_id,r_part_line.destination_subinventory
577: ,r_part_line.INVENTORY_ITEM_ID,r_part_line.serial_number,l_user_id);
578: END IF;
579: IF r_part_line.source_type='IO' THEN
580: FOR rec IN (SELECT USER_ID FROM CSP_REQ_LINE_DETAILS rld ,CSM_REQ_LINE_DETAILS_ACC acc
581: WHERE rld.SOURCE_TYPE='IO' AND rld.SOURCE_ID=r_part_line.line_id AND acc.REQ_LINE_DETAIL_ID=rld.REQ_LINE_DETAIL_ID)
582: LOOP --to update received qty
583: l_dummy := asg_download.mark_dirty(
584: p_pub_item => 'CSM_ORDER_LINES'

Line 853: FOR rec IN (SELECT USER_ID FROM CSP_REQ_LINE_DETAILS rld ,CSM_REQ_LINE_DETAILS_ACC acc

849: CSM_SERIAL_NUMBERS_EVENT_PKG.RECEIVED_MTL_SERIAL_NUM(r_part_line.destination_organization_id,r_part_line.destination_subinventory
850: ,r_part_line.INVENTORY_ITEM_ID,r_part_line.serial_number,l_user_id);
851: END IF;
852: IF r_part_line.source_type='IO' AND NOT l_dummy THEN
853: FOR rec IN (SELECT USER_ID FROM CSP_REQ_LINE_DETAILS rld ,CSM_REQ_LINE_DETAILS_ACC acc
854: WHERE rld.SOURCE_TYPE='IO' AND rld.SOURCE_ID=r_part_line.line_id AND acc.REQ_LINE_DETAIL_ID=rld.REQ_LINE_DETAIL_ID)
855: LOOP --to update received qty
856: l_dummy := asg_download.mark_dirty(
857: p_pub_item => 'CSM_ORDER_LINES'